| Posted by: rockafellerskank
- Dude [27652109] Thu, Nov 18, 2004, 18:58
I have 20,000 lines of data that all start with a date. Various dates from 1/1/01 to 11/15/04. I care about the "month" these transactions occured, but not necessarily the "day of the month" I want to convert them so that I can use them in a pivot table.
Obviously, I tried reformmating the date from 1/1/01 format to Jan-01 format which works fine, except when you create a pivot table, the table still thinks the dates are 1/1/04, 1/2/04, 1/3/04.... 1/31/04, etc.. So, my question is, how can I format not only the display of the data but the actual cell to read month-by-month?
I also didn'y really want to type a 48 If/Then true-false type of a statement if at all possible (to account for 48 separate months of transaction data). |