Extra noughts

[JohnJW]

I have obviously pressed an incorrect key. Each time I type a number, it appears on the worksheet with 2 noughts added - e.g type 47 and it appears as 4700.

How do I revert to what it was before?

Regards
John W

 

[VoG]

Tools > Options > Edit tab, untick Fixed decimal places.

 

[AD_Taylor]

Its not in Format Cells, and formatted as a number with 2 decimal points?
I'm assuming not because then it would appear as 47.00

It may be some VBA code on your sheet that is doing it. If you right click on the sheet name at the bottom and click View Code, is there anything in there?

 

[JohnJW]

Dear VoG and AD Taylor
Many thanks for your prompt replies.
Followed your instructions,VoG, all now fixed. The "Fixed decimal place" box was showing
-2 (minus 2). Presuably the minus sign multiplies the input number by 10, 100 etc depending on the number following the minus sign,as against showing the number in a decimal format with the "point". Interesting.
Thank you both again.
John W