Number Format in Excel

M

Mary Varghese

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?
 
C

Carim

Hi Mary,

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

HTH
Cheers
Carim
 
B

Bob Phillips

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)
 
Top