If you're looking to display the currencies I would create a currency number
format. Right-click in the cells whose values you want to format as a
currency, and select format cells. Then select the Number tab--Currency.
Select the appropriate currency. Your yen currency will show the yen symbol,
your USD currency will show the $ symbol, etc.

Dave
--
Brevity is the soul of wit.


"Jac" wrote:

Hi,

I would like to concatenate the data in 2 different columns as shown below
into 1:-

CURRENCY_CODE TOTAL_OUTSTANDING_VALUE
MYR 6,864.00
MYR 6,864.00
MYR 82.60
MYR 76.00
MYR 276.60
MYR 106.40
USD 758.31
USD 1,411.00
USD 1,388.73
USD 2,797.11
JPY 1,504.83
JPY 690.40
JPY 139,941.00

Actually, I have found the ways to concatenate those data by using the
function Concatenate and using the &. But after those data have been
concatenated, the number in 2nd column became text.
So, is there any other way that we still can remain the value of number
after caoncatenated the data? Any advise...

Thanking in advanced.