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.

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.

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.