<div>
Check the XLSTART folder. &nbsp;If there is a file there, check it out. &nbsp;If it contains formatting all new workbooks will use that as default.<br />
<br />
It can usually be found here: C:Program Files/Microsoft Office/Office14/XLSTART
</div>


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

<div>
Sounds like the default template has been changed. <br />
See if this gets you pointed in the right direction. <br />
<a href="http://www.pchelps.com/2011/03/productivity-101-setting-up-excel-default-formatting/" rel="ugc">http://www.pchelps.com/2011/03/productivity-101-setting-up-excel-default-formatting/</a>
</div>


Sounds like the default template has been changed.
See if this gets you pointed in the right direction.
http://www.pchelps.com/2011/03/productivity-101-setting-up-excel-default-formatting/ [http://www.pchelps.com/2011/03/productivity-101-setting-up-excel-default-formatting/]

NormalStyle.png

<div>
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 <a href="http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-changes-number-format-after-saving/70ba3d96-b693-4aa1-85c6-657b3b838d2b" rel="ugc nofollow">Excel 2010 changes number format after saving</a>
</div>


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 [http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-changes-number-format-after-saving/70ba3d96-b693-4aa1-85c6-657b3b838d2b]

<div>
<div class="content wysiwyg-content">
Hi –<br />
<br />
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.<br />
<br />
Thanks
</div>
</div>


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.

Thanks

Excel 2010 default cell format

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.