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

Samsung Galaxy S9 review

Artist Helen Friel on designing paper models for everyone to make

What to expect at Apple's 27 March education event

Idées cadeaux pour geeks et tech addicts