Hi All,
I have custom formatted cells in my source table that are formatted as ND(#.##). This same formatting is used throughout the table, but the number in parentheses changes (there are also numbers only cells in my source table). I have attached a screenshot of a portion of the source table. I would like to use the same or similar format in my values section of a pivot table. Problem (for me anyway) is that the custom formatted cell is brought into the PT as a number and it has to be configured as a number to be in the values section of the PT. Is there anyway to show that the cell is "ND" and keeping the numeric value in the PT? The formatting does not have to be "ND" exactly, "<" will work also. If anyone has any ideas, they would be greatly appreciated! If applicable, I can use VBA code, although I am a beginner at best!
I have custom formatted cells in my source table that are formatted as ND(#.##). This same formatting is used throughout the table, but the number in parentheses changes (there are also numbers only cells in my source table). I have attached a screenshot of a portion of the source table. I would like to use the same or similar format in my values section of a pivot table. Problem (for me anyway) is that the custom formatted cell is brought into the PT as a number and it has to be configured as a number to be in the values section of the PT. Is there anyway to show that the cell is "ND" and keeping the numeric value in the PT? The formatting does not have to be "ND" exactly, "<" will work also. If anyone has any ideas, they would be greatly appreciated! If applicable, I can use VBA code, although I am a beginner at best!
