how can I change MMDDYY to YYYYMMDD?

  • Thread starter Thread starter mhayes
  • Start date Start date
M

mhayes

The formula =MID(C7,5,2) & LEFT(C7,2) & MID(C7,3,2) gets me to YYMMDD. I
can't figure out how to get the year in full (YYYY).
 
Show us what's in C7 because I doubt the formula you posted is going to give
the result you expect.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
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 Conversion 1
Roundup Function 4
DATE question 5
Excel date format YYYYMMDD 1
How do I change the date format? 3
counting records by month and year / date format issues 1
From MMDDYY to YYMMDD 8
Date Question 5

Back
Top