G
G Lykos
Greetings! A pivot table is reading data in which the "same" text-formatted
numbers in a source column that gets piecemeal-updated regularly are being
treated differently. This manifests itself as a number appearing
right-justified (no formatting) in a first pivot table block along with its
members and then the number again but now left-justified (again no
formatting) in a second block with its members.
Checked the source data - all numbers are formatted as text (.NumberFormat =
@). Only difference I could spot was doing a debug.print of one of each of
two "same" numbers, where .Value of both is '3071' while .Value2 of one is
'3071' and .Value2 of the other is ' 3071' (leading space or something).
If relevant - I believe the source column is set up with a range control
list of values. [Incidentally - tried to capture the .Value2 value with
leading space but keep getting the trimmed number - how can I capture
exactly what debug.print produces to a text string?]
What in the world is causing the numbers to be treated differently? Also,
it there an easy way to dump a cell attribute list to facilitate a
comparison between two cells in a situation like this.
Thanks for any ideas!
George
numbers in a source column that gets piecemeal-updated regularly are being
treated differently. This manifests itself as a number appearing
right-justified (no formatting) in a first pivot table block along with its
members and then the number again but now left-justified (again no
formatting) in a second block with its members.
Checked the source data - all numbers are formatted as text (.NumberFormat =
@). Only difference I could spot was doing a debug.print of one of each of
two "same" numbers, where .Value of both is '3071' while .Value2 of one is
'3071' and .Value2 of the other is ' 3071' (leading space or something).
If relevant - I believe the source column is set up with a range control
list of values. [Incidentally - tried to capture the .Value2 value with
leading space but keep getting the trimmed number - how can I capture
exactly what debug.print produces to a text string?]
What in the world is causing the numbers to be treated differently? Also,
it there an easy way to dump a cell attribute list to facilitate a
comparison between two cells in a situation like this.
Thanks for any ideas!
George