Convert Date to MMYY

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

Guest

Need macro or other way to convert full (MMDDYY) dates to Month and Yr (MMYY)
 
Just format cells ..custom..type in what you need.

Regards
Bill K
 
If you want a string with that, then use =TEXT(A1,"mmyy")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Sumif date range 2
Convert Date 3
Getting Month Name 1
Sumproduct with nested if statement 5
Select Case 6
Which is the best MBOX Converter Tool different formats conversion? 4
How can you format a date/time datatype to read month and year? 1
Validation of Field 3

Back
Top