| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Entries show as decimal
Cell entry 100 shows as 0.01. What to do?
-- Saskatoon Jerry |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Entries show as decimal
Sounds like you've set fixed decimal places.
Goto ToolsOptionsEdit tabuncheck Fixed decimal placesOK -- Biff Microsoft Excel MVP "Saskatoon Jerry" wrote in message ... Cell entry 100 shows as 0.01. What to do? -- Saskatoon Jerry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| my cell entries are automatically being displayed as a decimal? | Excel Discussion (Misc queries) | |||
| Formula to show non decimal hours | Excel Discussion (Misc queries) | |||
| Limiting Validation entries to 2 places after a decimal | Excel Discussion (Misc queries) | |||
| How Show decimal in Bar Function | Excel Worksheet Functions | |||
| Show a time from one calculated cell as a decimal in another cell. | Excel Worksheet Functions | |||
Linear Mode
