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.
 
Back
Top