Convert Date to MMYY
 

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

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

Regards
Bill K
"Hudd" wrote in message
...
Need macro or other way to convert full (MMDDYY) dates to Month and Yr
(MMYY)
--
Hudd

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

Swisse

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

--

HTH

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


"Hudd" wrote in message
...
Need macro or other way to convert full (MMDDYY) dates to Month and Yr
(MMYY)
--
Hudd