Date format (ROW) in Pivot Table

[tjharlan]

Hi,

I've created a pivot table is based on a worksheet of data. For simplicity, let's assume the worksheet has two columns:

Date
Amount

The pivot table is setup with "Date" as the ROW and "Sum of Amount" as the COLUMN.

The problem is, that on the data worksheet, the format of the Date column is "Mar-98" - but, the pivot table displays the date as "3/1/1998". I want the pivot table to preserve the formatting (i.e., "Mar-98"). I know that for COLUMN data in the pivot table, you can set the NUMBER format. However, I don't see how to do this with ROW data.

Any suggestions?

Thanks and regards,

T.J.

 

[FinancialAnalystKid]

Select the date data in the pivot table and right click.
Select FORMAT CELLS.
Select NUMBER TAB.
Select Date and format as you like.

 

[tjharlan]

Thank you for the response.

However, this solution only works if no new rows will be added in the future. Any new row that gets added to the pivot table reverts back to the "3/1/1998" format.

Any other suggestions?

Thanks for the time.

 

[FinancialAnalystKid]

Good question. You might want to record a macro to format the date column.

 

[tjharlan]

Good idea. I will do that unless someone else has a better idea.

Thanks again for the help.