View Single Post
  #1   Report Post  
~Dave~
 
Posts: n/a
Default 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.