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

Is this possible?
--
Please help!

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.

"jlp" wrote:

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

Is this possible?
--
Please help!

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.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"trip_to_tokyo" wrote:

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.

"jlp" wrote:

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

Is this possible?
--
Please help!

--
Please help!


"jlp" wrote:

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

Is this possible?
--
Please help!

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.

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

Regards,
Fred

"jlp" wrote in message
...

--
Please help!


"jlp" wrote:

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

Is this possible?
--
Please help!

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.