Excel default number format problem

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?

http://www.imagedump.com/index.cgi?pick=get&tp=439712
http://i110.photobucket.com/albums/n...mpsonexcel.jpg

Maybe....

Format|Style Name|Select Normal|click Modify
and change the number format.

But styles live with workbooks--you may have to find the template file that is
used when a new workbook is created (if it really happens with a brand new
workbook).

Search for book.xlt in XLStart
open it
change that style
save and close book.xlt (to the same location as a template)

Close excel and reopen and test it out.

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?
>
> http://www.imagedump.com/index.cgi?pick=get&tp=439712
> http://i110.photobucket.com/albums/n...mpsonexcel.jpg

--

Dave Peterson