May 14, 2008 #1 rnordquest New member Jul 17, 2003 148 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.
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.
May 14, 2008 Thread starter #2 rnordquest New member Jul 17, 2003 148 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. Upvote 0 Downvote
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.
May 14, 2008 #3 joerd Chemical Sep 27, 2002 531 [tt]=DATEVALUE(" 14May2008")[/tt] Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips. Upvote 0 Downvote
[tt]=DATEVALUE(" 14May2008")[/tt] Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
May 14, 2008 1 #4 IRstuff Aerospace Jun 3, 2002 44,758 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 Upvote 0 Downvote
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
May 14, 2008 Thread starter #5 rnordquest New member Jul 17, 2003 148 Joerd is right. It's already in a scatter chart. Thanks guys. Upvote 0 Downvote
