|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 19th 10, 04:21 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Date to MMYY format
I would like to change the underlying date format from e.g. 01-May-09 to
May-09. I can change the format so that the displayed date is in correct format but the underlying date is still in DD/MM/YYYY format. The purpose is to do pivot charts to show how many defects per month over the last five years. -- Doug M 
|
| Ads |
|
#2
January 19th 10, 04:28 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Date to MMYY format
Rather than reformat the cell to Custom > mmm-yy
use something like: =TEXT(A1,"mmm-yy") -- Gary''s Student - gsnu200909 "Doug Muegge" wrote: > I would like to change the underlying date format from e.g. 01-May-09 to > May-09. I can change the format so that the displayed date is in correct > format but the underlying date is still in DD/MM/YYYY format. The purpose is > to do pivot charts to show how many defects per month over the last five > years. > -- > Doug M
|
|
#3
January 19th 10, 06:09 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Date to MMYY format
This solution worked perfectly - Thank you - saved me considerable time!!!
-- Doug M "Doug Muegge" wrote: > I would like to change the underlying date format from e.g. 01-May-09 to > May-09. I can change the format so that the displayed date is in correct > format but the underlying date is still in DD/MM/YYYY format. The purpose is > to do pivot charts to show how many defects per month over the last five > years. > -- > Doug M
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I convert dd/mm/yy date format to yyddd Julian date format | itzy bitzy[_2_] | Excel Worksheet Functions | 8 | December 11th 09 03:20 AM |
| Convert european foreign date format to US date format | EAL | Excel Worksheet Functions | 1 | May 14th 09 10:02 PM |
| convert serial date format to normal date format | Flagworld | Excel Discussion (Misc queries) | 3 | September 23rd 08 01:32 PM |
| Convert date + time text format to date format | Paul Ho | Excel Worksheet Functions | 2 | May 22nd 07 05:47 PM |
| Convert Date to MMYY | Hudd | Excel Discussion (Misc queries) | 3 | January 25th 05 09:15 PM |
Linear Mode
