Number definition in excel

[shani2006]

When ever I type number in a cell For exemple 120 it is show 1.2 or 1 will be seen 0.01

how do I change it. when I go to cell proporty it doesn't help.

Thanks for the help

Shani

[#2 · Accepted solution]

Look in File, Options, Advanced, "Automatically insert a decimal point" and uncheck that box.

[#3]

thanks, it solved the problem

@Jan Karel Pieterse