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
 

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 Format 1
date format problem 4
Excel How to change the "Short Date" format in Excel? 4
Date Format Problem. 2
TEXT function international dates 4
Dates show up as a 5 digit number in Excel 2007 3
date format in excel imported from an SQL DB. 2

Back
Top