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!