There is a method of doing what you want, without having to individually
format each cell. Example:

=CONCATENATE(B1," ",A1)

That will display precisely the contents of the cells without changing the
formats of either column's information.

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