Excel Text Date to Real Date 1

[rnordquest]

How would I reformat a text date to make it a real date? It's in the form 14May2008 right now but in a plot it's just 1 and the next date is 2.

 

[rnordquest]

Some more intel - the date is really in this form " 14May 2008". It's got a couple spaces in front. I guess I need a macro to change them all.

 

[joerd]

[tt]=DATEVALUE(" 14May2008")[/tt]

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[IRstuff]

The problem is not the date, it's your chart type. Right click the chart and select XY (Scatter) instead of the default Line chart.



TTFN

FAQ731-376

 

[rnordquest]

Joerd is right. It's already in a scatter chart.

Thanks guys.