Excel default number format problem

[Jason]

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 procedure:
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?
I have a screenshot posted on two sites in case one doesn't work:
http://www.imagedump.com/index.cgi?pick=get&tp=439712
http://i110.photobucket.com/albums/n111/nosaj19/gthompsonexcel.jpg

 

[Susan Ramlet]

Hi, Jason,

You don't tmention what version of Excel, but in 2003, go to Tools | Options
| Edit (tab), and see if the default decimal setting is set to 4.

 

[Harlan Grove]

Jason wrote...

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 procedure:
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?

....

Check if the user's Normal style uses 4 decimal places. From the Excel
menu, Format > Style... and check the Number format setting for the
Normal style.

If this happens in all workbooks, check if the user has templates named
Worksheet.xlt or Book.xlt, and if so, open them an check their Normal
style settings.