How to change text representing Value in a pivot table

RodneyC

Active Member
Joined
Nov 4, 2021
Messages
278
Office Version
  1. 2016
Platform
  1. Windows
I have a pivot table pulling data where one of the pieces of data is the date using this format m/d/yyyy.

This particular piece of data feeds into the Values field of the pivot table. When it does, instead of showing up as 3/1/2023 (m/d/yyyy) it shows up as Sum of 3/1/2023 I want to get rid of the "Sum of" portion. the data is pulling into a chart and I'd prefer not to have the Sum of element there.

I have clicked into PivotTable Analyze and looked at the Active Field and

1. Tried to delete the "Sum Of" portionhat doesn't work
2. Selected "Field Settings" and tried to Customize Name there. That doesn't work.

There's a couple other things I've tried there but nothing seems to work. Any ideas?

Thanks in advance
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Is that data in the Sum box of your Pivot Table?
 
Upvote 0
The data for each month is all in one column, including the top row which has the date
 
Upvote 0
No SUM formulas in the are where the Pivot table is pulling from.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top