Adding Zeroes

[Dodge29]

Hi

I have an issue whereby every time I want to enter a number I have to enter 2 zeroes after it so it shows up correctly. An example is if I just enter the number 5, it shows in the cell as 0.05. If I enter 500 then it shows up in the cell as 5. This is extremely frustrating and I cannot solve the problem. Please can someone help out?

Regards

 

[mole999]

what is the default cell format

 

[Jonmo1]

Welcome to the board.

In File - Options - Advanced.
UNcheck "Automatically insert a decimal point"

 

[Dodge29]

what is the default cell format

It is formatted for numbers, 1000 separator and decimal places 2