Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Default cell format
In Excel 2002 SP3 the default decimal place formatting in cell properties has
changed from 2 decimal places to 4. How do you change back? This has also affected the currency and decimal default formats. |
#2
|
|||
|
|||
Doug
One particular workbook or the default new workbook? FormatStyleNormalModify. Change the Number format to 2 decimal places. If you have a BOOK.XLT template in your XLSTART folder, you would have to change the Style settings in it. All workbooks? Could be your Windows Regional and Language Options got changed. StartSettingsControl PanelRegional and Language OptionsRegional OptionsCustomizeNumberNumber of digits after decimal. Gord Dibben Excel MVP On Thu, 30 Dec 2004 10:55:02 -0800, Doug S <Doug wrote: In Excel 2002 SP3 the default decimal place formatting in cell properties has changed from 2 decimal places to 4. How do you change back? This has also affected the currency and decimal default formats. |
#3
|
|||
|
|||
Doug -
Check Option, Edit, Fixed Decimal Places. It's probably at 4. Carole O "Doug S" wrote: In Excel 2002 SP3 the default decimal place formatting in cell properties has changed from 2 decimal places to 4. How do you change back? This has also affected the currency and decimal default formats. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format one data series, with error bars, and use it as default | Charts and Charting in Excel | |||
I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) | |||
make a conditional format the default | Excel Discussion (Misc queries) | |||
Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) | |||
How can I change the default 'comma' format. Eg paranthesis inste. | Excel Discussion (Misc queries) |