1
I received an Excel file containing an extract of sales forecasts. There is no column explicitly defining currency unit. Currency unit is only shown by number formatting (GBP, EUR or CHF). Does anyone know how can I detect the currency format in order to apply appropriate exchange rate for the different currencies?
Example:
Displayed Number Format / Actual Number in Cell
200,000 GBP / 200000
10,000 CHF / 10000
500,000 EUR / 500000
Many thanks, Tym
HI Gary's Student, thanks so much for creating and explaining the UDF above. If you have the time I would really like to understand what is occurring on each line, no problem if you don't. This was really easy to implement and produced the output I was seeking. I realised last night that I didn't specify what output I was hoping to achieve, apologies for that. Thanks, Tym – Tym Burman – 2019-01-29T08:49:34.477