Date Function

[Dte]

How can I change 20030610 to read as a valid format (06/10/2003, etc).

 

[J.E. McGimpsey]

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.

 

[J.E. McGimpsey]

So did you try it? Use the ymd option.

 

[Dte]

Yes "ymd" did work!

-----Original Message-----
So did you try it? Use the ymd option.


.