Number Format in Excel

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

Guest

When I type a nymber, it gets converted to that number divided by 100. For
example if I type 100 in the cell, it gets converted to 1.00. How do we set
it right?
 
Hi Mary,

In the menu Format Cells Number
and make your selection with the number of decimals needed ...

HTH
Cheers
Carim
 
Goto Tools>Options and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top