Number Format in Excel
 

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?

Number Format in Excel
 

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

Number Format in Excel
 

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?