Excel Chart

I have been charting two columns of data --'value' and 'date' to a line chart.When I move the cursor to the line it shows 'series 'value' point (date) and and the 'value' at that point. Recently the date(ie '9/4') does not appear-instead it is replaced with a five digit number(ie'39329').I use Excel 2000
How can I retrive the 'date'??

Tags: windows, excel, office

fran_lew1@...

Updated - 5th Sep 2007

Answer the Question

Answers (1)

Preferences

0 Votes

+ -

i think it is cell format

I think it is just a matter of cell formatting.. copy those number to a cell and change the cell formatting from general/number to date/time format

hope that helps... TQ

gerila_7@...

1st Jan 2008