Assuming the last col is col F, data from row1 down, and if the currency
code are all 3 alphas ("HKD", "SGD", etc) at the rightmost end, then this
might suffice:

Put in say, G1: =LEFT(F1,LEN(F1)-3)+0
Format G1 as currency, fill down
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Freshman" wrote in message
...
Dear all,

I downloaded a file from an external program in Excel format. The file
contains 6 columns with the prices at the last column. I tried to sum up
the
last column but found that the figures together with other text are in
"General" format - e.g. "$450.00HKD". As such, I cannot do any
calculations.
Since the last column has 600+ rows and I don't want to change the cell
format one by one. Would any experts tell me how to change the cell value
to
"$450.00" in currency format?

Thanks.