Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change General Format to Currency Format
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format change after printing in excel | Excel Discussion (Misc queries) | |||
Changing format of column from "general" to "currency" | Excel Discussion (Misc queries) | |||
How do I change the default format for a comment? | Excel Discussion (Misc queries) | |||
How can I keep a cells format, general, from changing after enter. | Excel Discussion (Misc queries) | |||
How can I change the default 'comma' format. Eg paranthesis inste. | Excel Discussion (Misc queries) |