98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Pivot tables
excel.advanced.course - Pivot tables
Resolved · Low Priority · Version Standard
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving between split pane sections in a spreadsheetIf you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections: |
