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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date format 1
Date formatting... 6
Covversion of date formats 2
Date Conversion in Excel 2007 4
Is Access 2003 overiding Regional date Settings? 4
convert 13.11.2009 general to 13/11/2009 date, how to 1
Excel import - formatting question 3
Date Format - US to English 6

Top