| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wrong number displayed.
Doesn't matter if I'm working in an old spreadsheet or a brand new one.
When I type "1" I get a result of "0.00001" (shows as 0 to 0.0000 if I don't have enough decimal places revealed). When I type "100000" I get a result of "1". If I type "1." (with the decimal) I get a result of "1". |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wrong number displayed.
Toolsoptionsedit and deselect the fixed decimal places
-- Regards, Peo Sjoblom "Bob" wrote in message ... Doesn't matter if I'm working in an old spreadsheet or a brand new one. When I type "1" I get a result of "0.00001" (shows as 0 to 0.0000 if I don't have enough decimal places revealed). When I type "100000" I get a result of "1". If I type "1." (with the decimal) I get a result of "1". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Value displayed on graph is wrong- but graph is right? | Charts and Charting in Excel | |||
| How can zero be displayed in Excel as the first number | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| How could the number, '102845678' be displayed as '10,28,45,67 | Excel Discussion (Misc queries) | |||
| Displayed number format | Excel Worksheet Functions | |||
Linear Mode
