Data format change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:
I have some dates in plain text, e.g. 20040719. How can I transform it into date format? Also, how can I reverse it from dates to plain text?
Thanks in advance!
 
One way:

Select the dates. Choose Data/Text to Columns... Click OK, OK. Choose
YMD from the date dropdown and click Finish.

To convert to plain text:

=TEXT(A1,"yyyymmdd")
 
Back
Top