Excel default number format problem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Excel default number format problem 2
Excel default number format problem 9
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
how to change default decimal places in cell format 14
Peculiar default cell format 1
When I insert a worksheet the cell format is accounting 1

Top