SOLVED

Number definition in excel

Copper Contributor

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 Replies
best response confirmed by HansVogelaar (MVP)
Solution
Look in File, Options, Advanced, "Automatically insert a decimal point" and uncheck that box.

thanks, it solved the problem

@Jan Karel Pieterse 

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution
Look in File, Options, Advanced, "Automatically insert a decimal point" and uncheck that box.

View solution in original post