Home |
Search |
Today's Posts |
#1
|
|||
|
|||
number formatting
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. |
#2
|
|||
|
|||
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 "Ralf Riedel" wrote in message ... 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. |
#3
|
|||
|
|||
Go to ToolsOptionsEdit and uncheck the Fixed Decimal box.
-- HTH RP (remove nothere from the email address if mailing direct) "Ralf Riedel" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
Number Formatting | Excel Worksheet Functions | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) |