Forum Discussion
shani2006
Jan 18, 2024Copper Contributor
Number definition in excel
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
- Jan 18, 2024Look in File, Options, Advanced, "Automatically insert a decimal point" and uncheck that box.
JKPieterse
Jan 18, 2024Silver Contributor
Look in File, Options, Advanced, "Automatically insert a decimal point" and uncheck that box.
shani2006
Jan 21, 2024Copper Contributor
thanks, it solved the problem