Excel Whole Numbers

  osben 15:59 30 Apr 2004

In the past before I installed Windows XP, in my worksheets, when I put a whole number (say15) into a cell and pressed return, it showed as 15 now it shows as 1.50
I have gone into "format Cell" and the only thing I can do is to alter the number of decimal places which I have to 2. I have also looked in "Options" but can see nothing of any relevence.

Why has it suddenly changes and how do I overcome it?? Am I having a mental blockage.


  GroupFC 16:21 30 Apr 2004

I am not sure - but go to Control Panel>regional Settings and have a look around there and see if any thing obvious jumps out!

(at least this will bump you up the list!).

  osben 16:49 30 Apr 2004

Thanks for your input GroupFC but I have fixed it.

I knew it had to be something simple. I unticked "fix Decimal Places" in "options - edit"

Why it should change just because I now use Windows XP is a mystery.

Thanks anyway

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Best of the Grad Shows 2017: University of the West of England (UWE)

Best value Mac: Which is the best £1249 Mac to buy

Les meilleures GoPro 2017