Data format change

V

Vincdc

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!
 
J

JE McGimpsey

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default format type HTML Outlook 2013 0
.SRT - to plain text 1
Excel does not accept text format! 0
Microsoft word: fields are nested too deeply 1
Absolute position in Layout 2
VBA - exporting serial letters to single documents 0
Convert a text in a date format 2
MS Project. Real progress of the project, % complete 1

Top