Pivot Table - Currency

[jlp]

I am producing a pivot table with prices in £'s and $'s but unable to get the
currency symbol to display.

Is this possible?

 

[trip_to_tokyo]

EXCEL 2007

Yes.

I have just tested this.

Set up Pivot Table to be half in dollars and half in pounds.

Saved file and closed it.

Re-opened file.

Pivot Table was still formatted half in dollars and half in pounds.

I formatted in the, "normal" way:-

- highlighed those cells I wished to format

- Home group / Font / clicked on arrow in lower right hand corner / Format
Cells launched / Number tab / Currency / then selected either pounds or
dollars in Symbol: field and hit OK.

Please hit yes if my comments have helped.

Thanks.

 

[KC hotmail com>]

Formatting the cells in a pivot table worksheet is not a great idea because
refreshing the pivot table may or may not retain the formatting, especially
if it has to expand due to having more data.

It's better to right-click each field and format the "Field Settings"
"Number Format" to what you're looking for. Then that field will always
utilize that number format, even after a pivot table refresh.

Excel 2007 seemed to have no problem for me allowing 2 different currency
types in one pivot table.

 

[jlp]

--
Please help!

I am producing a pivot table with prices in £'s and $'s but unable to get the
currency symbol to display.

Is this possible?

The raw data has a combination of £'s and $'s. Can the pivot table pick up
the information automatically.

Product A € 4.52 kg
Product B £3.17 kg

Once the pivot table is created the price looses all formatting.

 

[Fred Smith]

Help was provided. What was wrong with the answers provided?

Regards,
Fred