Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number Formatting
I have a user who's numbers in excel are defaulting to a decimal even if you
format the cell for number zero decimal places. For example if she enters 15 it will enter .15. This happens on every excel document she opens and if you open the same documents on another PC they work fine. I have even tried to reinstall excel on the PC and it does not correct the Issue. Please help with suggestions. For a work around I have her entering 15. But that is an extra key stroke. Thanks |
#2
|
|||
|
|||
go to ToolsOptionsEdit and uncheck the option for Fixed Decimal Places
"Shane" wrote: I have a user who's numbers in excel are defaulting to a decimal even if you format the cell for number zero decimal places. For example if she enters 15 it will enter .15. This happens on every excel document she opens and if you open the same documents on another PC they work fine. I have even tried to reinstall excel on the PC and it does not correct the Issue. Please help with suggestions. For a work around I have her entering 15. But that is an extra key stroke. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
How do I do conditional formatting on number formats not patterns. | Excel Discussion (Misc queries) | |||
Number formatting | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |