techman222 06:42 09 Mar 10

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 10

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

  John B 07:27 09 Mar 10

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced