| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get a sum for variant currency values
Hi gurus,
I've been searching for the topic but found nothing relevant. Say there's a column A like this - EUR 100 USD 200 CNY 300 YEN 400 How can I get the sum of those values? The currencies were set by "cell format" so they're not part of the text. Any input would be appreciated. Best, Yu |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i sum values with Different currency Format? | Excel Discussion (Misc queries) | |||
| String to Variant incorrect conversion | Excel Worksheet Functions | |||
| How do I assign range to variant and use | Excel Discussion (Misc queries) | |||
| Increase a currency grid values by 3% | Excel Discussion (Misc queries) | |||
| Why are some currency values of 0 in red? I want all black. | Charts and Charting in Excel | |||
Threaded Mode
