Hi,
I would like to have a smart icon similar to $ sign for Euros and GBP
as shown in the below example. If a smart icon is not possible, at
least I want to be able to format the numbers to show that they are a
different currency. Could you please explain how to insert currency
sign in front of a number that is different than USD?


JAN PURCHASES - USD $1,831,955 $374,535


JAN EXPOSURES LOCAL CURRENCY € 1,343,864 £193,959


Thanks for your help.

Regards,
BGN2.


--
bgn2
------------------------------------------------------------------------
bgn2's Profile: http://www.excelforum.com/member.php...o&userid=25774
View this thread: http://www.excelforum.com/showthread...hreadid=470449