ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 Cell Format Changed (https://www.excelbanter.com/excel-discussion-misc-queries/209366-excel-2007-cell-format-changed.html)

rakudave

Excel 2007 Cell Format Changed
 
I am having a problem where when I open an existing spreadsheet some of my
cells are reformatted as dates. Now it could be happening when I close the
file (it's sort of hard to tel 'til I open it). This is happening with
multiple spreadsheets and on multiple Office 2007 installations. Note that
all spreadsheets are derived from the same template.

Thanks.

-rakudave

rakudave

Excel 2007 Cell Format Changed
 
Check out
http://www.microsoft.com/office/comm...2fsettings.xml

I still don't know how this setting got changed, but I suspect that one of
my users is making this change without realizing the extent of it's effect.

-rakudave


"rakudave" wrote:

I am having a problem where when I open an existing spreadsheet some of my
cells are reformatted as dates. Now it could be happening when I close the
file (it's sort of hard to tel 'til I open it). This is happening with
multiple spreadsheets and on multiple Office 2007 installations. Note that
all spreadsheets are derived from the same template.

Thanks.

-rakudave



All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com