When i enter 10000 in a cell it is showing only 100

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi There !

I am clue less exactly what happend to my Excel.
When ever i enter a numerical value Say 10000 it is showing 100
if i enter100 it is showing 1

Could some one can suggest a remedy please....
 
In Excel, click on Tools | Options | Edit | uncheck the "Fixed
decimal places" box | OK.
 
Back
Top