Convert Date to MMYY

[Hudd]

Need macro or other way to convert full (MMDDYY) dates to Month and Yr (MMYY)

 

[Bill Kuunders]

Just format cells ..custom..type in what you need.

Regards
Bill K

 

[swisse]

You have to custom format your cells to type MM YY.

Swisse

 

[Bob Phillips]

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

--

HTH

RP
(remove nothere from the email address if mailing direct)