Date Changes to General

M

Michael

We have worksheets with dates in them. They are formatted at Month and
year (Nov-09 mmm-yy for 11/16/2009. Sometimes when I open the sheets
the formatting is lost and the dates are show as general numbers 40134
in this case. Any idea why this happends? We share workbooks in the
office - could it be that custom formats are not stored witth the
file?

any ideas of how to fix this annoying problem would be helpful.

Thanks
 
O

Otto Moehrbach

Formatting is stored with the file. Could it be that someone is
inadvertently changing the format of those cells? HTH Otto
 
Top