Date Changes to General

  • Thread starter Thread starter Michael
  • Start date Start date
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
 
Formatting is stored with the file. Could it be that someone is
inadvertently changing the format of those cells? HTH Otto
 
Back
Top