How can I change 20030610 to read as a valid format (06/10/2003, etc).
J J.E. McGimpsey Oct 3, 2003 #2 Select your cell/column. Choose Data/Text to Columns. Click Next, Next. Select ymd or ydm (your example is ambiguous) from the Date dropdown. Click Finish.
Select your cell/column. Choose Data/Text to Columns. Click Next, Next. Select ymd or ydm (your example is ambiguous) from the Date dropdown. Click Finish.
D Dte Oct 4, 2003 #4 Yes "ymd" did work! -----Original Message----- So did you try it? Use the ymd option. . Click to expand...
Yes "ymd" did work! -----Original Message----- So did you try it? Use the ymd option. . Click to expand...
