muffin1947 20:31 18 Sep 06

I am just using excel to do my accounts and I have one column down into which I put the amount going out.But now when I enter the sum and click onto the next column the amount I have just entered changed to a date format.When I clear that column and re-enter the amount the same thing happens again it changes to a date format.Does anyone know what I have done wrong.I have been doing my accounts this way for years and this has only started last week.Can anyone help.


  skidzy 20:33 18 Sep 06

Here comes VoG™ to the rescue...

  ScanJet 20:37 18 Sep 06

If you select the column / cells in question and right click and choose 'format cells' you will be able to select 'number' from the tabs and then 'number' again from the list. This will set it as required, you can then change the number of decimal places etc.

Its probably because this cell / column had a date in it previously that it defaulted to 'date'.

Hope this works

  Noldi 20:37 18 Sep 06

You need to select the cells and format > Cells to Accounting,

  Noldi 20:51 18 Sep 06

click here
Maybe worth a read.


  wolfie3000 20:51 18 Sep 06

No VOG post?

Im shocked.

  skidzy 20:53 18 Sep 06

Exactly Wolfie...hence my post earlier :-)))

  VoG II 21:03 18 Sep 06

Click on the column header, Format > Cells and format as currency.

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

Sony Xperia XZ Premium review: Hands-on with the new 4K HDR phone with Motion Eye camera and Snapdr5…

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

Best laptop for design and art 2017: we test Apple, Dell, HP, Lenovo and Microsoft's most powerful…

Apple Watch 2 vs Huawei Watch 2 comparison review: watch out for 4G smartwatches Apple