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

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

How to use 3D Touch on iPhone

Comment importer des contacts d’un iPhone à un autre iPhone ?