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 Format 1
Concatenate Text, Number and Date 2
Covversion of date formats 2
Find the position of a date 6
Week starts on Friday 3
Is Access 2003 overiding Regional date Settings? 4
convert 13.11.2009 general to 13/11/2009 date, how to 2

Top