| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
settings
I have lost all of my previous settings and formulas in all excel spread
sheets. ie: I type the # 10 - it was set to displsy as 10.00 - now it shows as .10. When I try to re-format the cells I choose 2 dicimal positions but still get .10 |
|
#2
|
|||
|
|||
|
Uncheck the box "Fixed Decimal" found under Tools
Options Edit tab. HTH Jason Atlanta, GA -----Original Message----- I have lost all of my previous settings and formulas in all excel spread sheets. ie: I type the # 10 - it was set to displsy as 10.00 - now it shows as .10. When I try to re-format the cells I choose 2 dicimal positions but still get .10 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preserve Excel page settings | Excel Discussion (Misc queries) | |||
| file access & options settings | Excel Discussion (Misc queries) | |||
| [Excel] How do I change the default import external data settings. | Excel Discussion (Misc queries) | |||
| Opening Excel after changing settings and add-ins | Excel Discussion (Misc queries) | |||
| how to clear the recently used files and still keep settings to k. | Excel Discussion (Misc queries) | |||
Hybrid Mode
