| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change default decimal places?
I have a user with an incorrect default cell format in Excel. His
default number of decimal places for a cell with numbers is set to 4 instead of 2. I have no idea how he caused this and I have no idea how to correct it. In case I'm being ambiguous, here is the procedu Open a new Excel workbook, choose any cell and go to Format. In the Format Cell dialog box go to the Number tab and choose the Number category. The Decimal Places box will be set to 2 by default but in this user's Excel it is set to 4. How do I get it back to the default of 2? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How many decimal places can a cell display? | Excel Worksheet Functions | |||
| How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
| How to change default cell format to "Text" | Excel Discussion (Misc queries) | |||
| How do I change the number of decimal places displayed in Excel | Excel Discussion (Misc queries) | |||
| Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
Threaded Mode
