| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Convert Date to MMYY
Need macro or other way to convert full (MMDDYY) dates to Month and Yr (MMYY)
-- Hudd |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
You have to custom format your cells to type MM YY.
Swisse |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONVERT 11/23/04 US DATE FORMAT TO EUROPEAN 23/11/04 FATE | Excel Discussion (Misc queries) | |||
| convert julian date to gregorian date | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
Hybrid Mode
