| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy
How do I convert a date in mm-dd-yy format to a mmm format so that a pivot
table reads the mmm format, not the mm-dd-yy format? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy
format cell, select "Custom" from left side, in the "Type:" field, enter
"mmm" and press "OK" jat "Ethiesen" wrote: How do I convert a date in mm-dd-yy format to a mmm format so that a pivot table reads the mmm format, not the mm-dd-yy format? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you convert a pivot table to excel worksheet | Excel Discussion (Misc queries) | |||
| Convert Pivot table back to Data Table | Excel Discussion (Misc queries) | |||
| convert Pivot table back to Data table | Excel Discussion (Misc queries) | |||
| Convert Pivot Table to Normal Data table | Excel Discussion (Misc queries) | |||
| Pivot Table - How Do I Convert Data? | Excel Worksheet Functions | |||
Linear Mode
