Home |
Search |
Today's Posts |
#1
|
|||
|
|||
why do dates in excel charts change to 38159 for example
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Sometimes this happens when the chart is in a different workbook from
the data. If the source workbook is not open, Excel doesn't read the format that was applied to the data, so it just applied General number format. The way to minimize reformatting is to double click the axis before it messes up, go to the Number tab, and uncheck the Link to Source checkbox. This makes the chart remember the format, not get it from the source data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Bernard Liengme wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Excel Charts into Word Documents: font sizes change | Charts and Charting in Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
I'm loosing colour when copying charts from excel to word. | Charts and Charting in Excel | |||
Print multiple excel charts within one sheet to fit to a page lik. | Excel Discussion (Misc queries) | |||
Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) |