Excel default number format problem

  • Thread starter Thread starter Jason
  • Start date Start date
J

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?

http://www.imagedump.com/index.cgi?pick=get&tp=439712
http://i110.photobucket.com/albums/n111/nosaj19/gthompsonexcel.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.
 
Back
Top