Excel Whole Numbers

  osben 15:59 30 Apr 04

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 04

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 04

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.

Huawei P10 review

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

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now