Pivot Table - Currency

J

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?
 
T

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.
 
K

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.
 
J

jlp

--
Please help!


jlp said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top