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


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=531785

Goto ToolsOptions 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)

"Mary Varghese" <Mary wrote in message
...
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?