Need help to display variety of currencies

[venkatasuresh]

Hi Experts,

I have to display multiple currencies on list box &Pivot table

we have source data in .xlsm file.(PFA)

Input data:

  CURRENCY

£13,500.00
£26,000.00
$1,438,900.00
£15,500.00
£1,035.00
$59,228.29
CAD 321,793.00
$21,173.00
$5,840.00
£429,331.00
£63,284.00
$14,562.40
£89,656.00
SEK 68,793.30
£114,164.00
€32,500.00
£4,963.00
€ 37,000.00
£5,115.60

expected output:(list box/Pivot table):

CURRENCY

£13,500.00
£26,000.00
$1,438,900.00
£15,500.00
£1,035.00
$59,228.29
CAD 321,793.00
$21,173.00
$5,840.00
£429,331.00
£63,284.00
$14,562.40
£89,656.00
SEK 68,793.30
£114,164.00
€32,500.00
£4,963.00
€ 37,000.00
£5,115.60

Thanks,

Suresh V.V

[Anil_Babu_Samineni]

Do you really fell any difference from Input and Output? Might be I Haven't opened excel.

[venkatasuresh]

Hi Anil,

There is no difference i want to display input as it is on dashboard.

Thanks,

Suresh V.V

[Anil_Babu_Samineni]

Will you able to share screenshot your expectation? That would great