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

excel
  • JKPieterse's avatar
    JKPieterse
    Jan 18, 2024
    Look in File, Options, Advanced, "Automatically insert a decimal point" and uncheck that box.
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jan 18, 2024
    Look in File, Options, Advanced, "Automatically insert a decimal point" and uncheck that box.

Resources