multiple format in Pivot table

[Raghava@rock]

Hi Team,

I am looking for help in preserving the number format when pivot table is updated, in the attached file i hvae activity and hours , i need hours to be in general format and activity in currency format.

I tried to by selecting preserve cell format on update but no luck.

Appreciate you help in this regard.

 

[vletm]

@Raghava@rock
Your 'hours' were in 'general format'
and
'... Activity' is now in 'currency format'.

 

[Raghava@rock]

Hi , it still changes when I select the other value , like Actual hours and billed activity .

my need is to keep the format even when the value's selection is changed

 

[vletm]

@Raghava@rock
Have You used that [Number...]?

 

[Raghava@rock]

Hi Vletm,
I did try but it keeps changing as I change the Value fields.

Is there any better way to handle it , like when is select any hours field it should be in Number and any activity field with Currency format.

Appreciate you help in this regard

 

[vletm]

@Raghava@rock
Why do You need to change/add many times those value-fields?
Make a plan ... do settings ... and then it's ready.
I have noticed that my setting have changed ... so far.