| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why does 26000 display as 260.00 after formatting for numbers
Although the cells have been formatted for numbers, entries are displayed as
one hundredth of the keyed in number. How do I get the displayed number to be exactly as keyed in? |
|
#2
|
|||
|
|||
|
Go to ToolsOptionsEdit and see if the Fixed decimal box is checked. If so,
uncheck it. -- HTH RP (remove nothere from the email address if mailing direct) "shiv" wrote in message ... Although the cells have been formatted for numbers, entries are displayed as one hundredth of the keyed in number. How do I get the displayed number to be exactly as keyed in? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting dates in the future | Excel Worksheet Functions | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Linear Mode
