muffin1947 20:31 18 Sep 2006

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 2006

Here comes VoG™ to the rescue...

  ScanJet 20:37 18 Sep 2006

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 2006

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

  Noldi 20:51 18 Sep 2006

click here
Maybe worth a read.


  wolfie3000 20:51 18 Sep 2006

No VOG post?

Im shocked.

  skidzy 20:53 18 Sep 2006

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

  VoG II 21:03 18 Sep 2006

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

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

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?