| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel 2002 Pivot Table Date
What format should the date be to use the year portion (database is only two
digits) as rows or columns? The current date format is 12-JAN-98. All transactions will total by year. Example: Transactions: 02 03 04 xxxxxxxxxxx xxxxxxxxxxx Transactions are summarized by G/L. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grouping in Excel on a Pivot table, need to be able to retrive ex. | Excel Discussion (Misc queries) | |||
| How to group date in pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table in Excel 2002 | Excel Discussion (Misc queries) | |||
| Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions | |||
| How do I display a data table in an Excel 2002 chart? | Charts and Charting in Excel | |||
Threaded Mode
