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.