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

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone