Q: date convert

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

Guest

Hello,
How can I convert the date with the format YYYYMMDD to MM/DD/YYYY with a
formula?
Thanks,
 
Hi

With date in A1
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
and format in any valid date format
 
Assuming the date is numeric, something like:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

HTH
 

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

Excel date format YYYYMMDD 1
Excel 2002: How to make the date format uniform ? 1
Date Seperator 2
How do I change the date format? 3
Convert dates stored as text 2
Handling date formats... 4
counting records by month and year / date format issues 1
INDEX MATCH but need to change return Values 2

Back
Top