Mark Hunt

Posts: n/a

how do I troubleshoot date formats in a pivot table report?

The date format appears only with the month (e.g. Jan) and not the year, even
though I have formatted the cells to show, e.g. Jan-05.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table services	Craig	Excel Discussion (Misc queries)	5	January 19th 05 06:11 PM
Pivot Table and Charts	anonymous	Excel Discussion (Misc queries)	3	December 21st 04 05:32 PM
Date Selection for Pivot Table	Burak Emer	Excel Discussion (Misc queries)	0	December 15th 04 08:19 AM
How to create a calculated field formula based on Pivot Table resu	dha17	Excel Discussion (Misc queries)	1	December 15th 04 05:39 AM
pivot table multi line chart	souris	Charts and Charting in Excel	2	December 7th 04 03:56 AM

All times are GMT +1. The time now is 06:02 AM.

About Us

"It's about Microsoft Excel"