Wed 23 Jan 2008, 16:39Delegate Morounke said...
Morounke has attended:
Excel Advanced course
Pivot tables
If I have exported data from Sage (transaction listings) and want to creat pivot table with heading including months. How do I format date to read say April07 instead of 01/04/07 as this makes grouping transaction difficlut.
Wed 6 Feb 2008, 11:56Trainer Katie said...
RE: Format Dates
Hi Morounke,
Generally in Excel, if you want to select the entire column of dates & format, you can do the following:
- 1. Click on the first date of the column
2. Hold on CTRL + SHIFT + down arrow, to highlight the entire list
3. FORMAT menu -> Cells
4. Choose NUMBER tab -> CUSTOM category
5. Under "Type", key in the syntax mmmyy
6. Press OK
See if that works.
Regards,
Katie Woo
Microsoft Certified Trainer
