If I understand you correctly, the data may have imported as text, including
the HKD suffix.
If so, Select your last column and use Edit/Replace to find instances of HKD
and replace with nothing.
Rgds,
ScottO

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