Forum Discussion

shani2006's avatar
shani2006
Copper Contributor
Jan 18, 2024
Solved

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
  • JKPieterse's avatar
    Jan 18, 2024
    Look in File, Options, Advanced, "Automatically insert a decimal point" and uncheck that box.

Resources