• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 670
  • Last Modified:

Excel 2010 default cell format

Hi –

Is anybody aware of a setting to change all cells to default to date format? This has happened and we can’t figure out how to set it back to normal. So even when a new worksheet in opened it defaults to date format.

1 Solution
Check the XLSTART folder.  If there is a file there, check it out.  If it contains formatting all new workbooks will use that as default.

It can usually be found here: C:Program Files/Microsoft Office/Office14/XLSTART
Gary DewrellSenior Network AdministratorCommented:
Sounds like the default template has been changed.
See if this gets you pointed in the right direction.
paullordAuthor Commented:
No files in this folder
There were a number of complaints like this some months back. At the time, it was believed that the Normal style was corrupted. Please make sure that the normal style uses the General number format. To check:
1.  On the Home menu, select Cell Styles
2.  Rightclick the Normal style in the resulting dialog, then choose Modify...

You should see a dialog like shown below:
Style modification dialog
Assuming that style corruption is the root problem, some people have reported that it results after you copy data from one instance of Excel to another. This cause is discussed in a Microsoft Answers forum thread Excel 2010 changes number format after saving
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now