techman222 06:42 09 Mar 2010

I have just been working on our bank statement and I entered the date in the cell meant for the amount of money.I cleared the contents of that line but now even though I enter a amount of money in that cell when I move to another cell it changes back to the date I wrongly entered.I have done this before but have forgotten how to change it back to currency.Can someone advise.

  KremmenUK 07:24 09 Mar 2010

Right click the cell > Format Cells > Number Tab (select currency)

  John B 07:27 09 Mar 2010

Right click the cell. Format, and under number, click currency.

In some versions of Excel there may a shortcut on the tool bar (it looks like a pile of coins).

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Intel Coffee Lake release date and specifications

These beautiful, mesmerising & subtle GIFs celebrate 30 years of the artform

watchOS 4 review

Les meilleurs navigateurs internet 2017