| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Date format
I have a date 1/25/2008 and I want to format to 1/2008 with the format still
being a date not text so that it will pivot on a chart with that info. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert Date format
Hi,
Choose Format, Cells, Number tab, Custom and on the Type line enter M/YYYY Cheers, Shane Devenshire Microsoft Excel MVP "Newbee" wrote in message ... I have a date 1/25/2008 and I want to format to 1/2008 with the format still being a date not text so that it will pivot on a chart with that info. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert Date format
Format the number using the Custom option. Under Type key in m/yyyy
"Newbee" wrote: I have a date 1/25/2008 and I want to format to 1/2008 with the format still being a date not text so that it will pivot on a chart with that info. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert Date format
If you format as m/yyyy what do you get?
Note that formatting has nothing to do with underlying values. If you group the dates using month and year you will get the chart showing per month as well -- Regards, Peo Sjoblom "Newbee" wrote in message ... I have a date 1/25/2008 and I want to format to 1/2008 with the format still being a date not text so that it will pivot on a chart with that info. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert Date format
I tried that but when I pivot table the information. It is not a date
anymore it seems to be text. "Peo Sjoblom" wrote: If you format as m/yyyy what do you get? Note that formatting has nothing to do with underlying values. If you group the dates using month and year you will get the chart showing per month as well -- Regards, Peo Sjoblom "Newbee" wrote in message ... I have a date 1/25/2008 and I want to format to 1/2008 with the format still being a date not text so that it will pivot on a chart with that info. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert European Date format to American Format | Excel Discussion (Misc queries) | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
| How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
Linear Mode
