Default cell format

[Guest]

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.

 

[Gord Dibben]

Doug

One particular workbook or the default new workbook?

Format>Style>Normal>Modify.

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.

Start>Settings>Control Panel>Regional and Language Options>Regional
Options>Customize>Number>Number of digits after decimal.

Gord Dibben Excel MVP

 

[Guest]

Doug -

Check Option, Edit, Fixed Decimal Places. It's probably at 4.

Carole O