P
Peter
Hello
I am using Excel 2010 and have from time to time a strange situation.
In my pivottable I have 4 fields in the rows. (No report filter,
column or Values in this example)
The first 2 fields are pure text and the next 2 are numbers.
I want to format the numbers, but the Number Format button is only
shown for one of the fields, not for the other. I dosn't matter which
one is shown as field 3, and it dosn't matter if I only show the
number fields and not the text fields.
My data comes from an sql-base and the formats are different: The one
that I can change the number format for is numeric(28,12) NOT null.
The other field is formated as numeric(36,6) null. Is this difference
the answer ?
Can anyone tell me what the problem is ?
Regards
Peter
I am using Excel 2010 and have from time to time a strange situation.
In my pivottable I have 4 fields in the rows. (No report filter,
column or Values in this example)
The first 2 fields are pure text and the next 2 are numbers.
I want to format the numbers, but the Number Format button is only
shown for one of the fields, not for the other. I dosn't matter which
one is shown as field 3, and it dosn't matter if I only show the
number fields and not the text fields.
My data comes from an sql-base and the formats are different: The one
that I can change the number format for is numeric(28,12) NOT null.
The other field is formated as numeric(36,6) null. Is this difference
the answer ?
Can anyone tell me what the problem is ?
Regards
Peter