Date Formatting

  • Thread starter Thread starter Ivan Teodorovic
  • Start date Start date
I

Ivan Teodorovic

I'm trying to convert a text format of "mmddyy" to a date
format of "mm/dd/yy".

Please advise!

Thanks.
 
This will result in a TEXT format "mm/dd/yy". To get an actual date, try
=DATE("20"&RIGHT(A1,2),LEFT(A1,2),MID(A1,3,2))
and format the cell with date format mm/dd/yy.
 
You must log in or register to reply here.

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

Date format 050180 to 05/01/80 11
Preserving date format 1
converting date to text 2
Convert military date system to standard date system 8
date format 1
Date Format 9
Convert date to text without changing format dd/mm/yy 3
Conditional formatting of date-cell - 2007 5

Back
Top