Strikethrough Data not appearing in Pivot Table

Excel_Trainee

New Member
Joined
Apr 2, 2020
Messages
6
Office Version
  1. 2013
Platform
  1. Windows
Excel Gurus,

Lets say that i have a column that has text data (some of which have strikethroughs). When i create a pivot table using that data, the strikethroughs are not coming through. How can I resolve this issue?

Eg.
Address
1004 N. Josey Ln.
1200 S. Randall Ave

When i do a pivot, the 1200 S. Randoll Ave does not show the strikethrough.

Please advise. Thank you in advance!

-Excel Trainee
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
As far as i know pivot tables don't take into account source formatting, if you want to filter out everything with a strike-through from your pivot you will need to add a column to your source data identifying what has and has not been struck-through and then filter this out of the pivot - but would be happy to be corrected by one of the experts
 
Upvote 0
Hello Dave87,

I understand that pivot table does not account for source formatting. However, I am looking for a way where the pivot table retains source formatting. I need the strike through data to show in my pivot table.

And thank you for your response!
 
Upvote 0

Forum statistics

Threads
1,223,956
Messages
6,175,612
Members
452,660
Latest member
Zatman

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