number formatting

[Ralf Riedel]

I just installed Office 03 and have a problem w/ excel. When I type a number,
it displays it as #/100. Eg, I type 5 and xl displays it as 0.05. The problem
persists after I clear the formatting for the cell. Anyone has a suggestion?
Thx,
Ralf.

 

[Chip Pearson]

Go to the Tools menu, choose Options, then the Edit tab. There,
uncheck the "Fixed Decimal" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...

 

[Bob Phillips]

Go to Tools>Options>Edit and uncheck the Fixed Decimal box.

--

HTH

RP
(remove nothere from the email address if mailing direct)