View Single Post
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

Not sure why it changes but it is not arbitrary. Excel stores dates a serial
number (1/1/1900 at midnight =0). Try this: enter todya's date in a cell and
then format it Number and you will see 38609.
Somehow your chart axis is getting reformamted.
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"lostindata" wrote in message
...

Dates on an excel chart seem to arbitrarily change from Feb 01, etc to
38159, etc.
This happens when I close the spreadsheet out and then send it to someone
as
an attachment. They open it and the dates do not show.