Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i convert dates to labes eg 01/01/02 to jan 02
DATES ARE HELD AS NUMERICS AND FORMATING ALLOWS YOU TO PRESENT THEM AS DATES
HOWEVER WHEN YOU USE PIVOT TABLES AND AND YOU WANT DATES GROUPED AS MONTHS OR YEARS ITS IMPOSSIBLE AS THE SOURCE DATE ISN'T HELD THAT WAY |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert dates stored as dates to text? | Excel Discussion (Misc queries) | |||
Convert dates | Excel Worksheet Functions | |||
Convert Dates | Excel Worksheet Functions | |||
How do i get data labes to appear on graph in pivot tables | Charts and Charting in Excel | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions |