Forum Discussion
Currency values downloaded to excel do not convert to numbers
Hello. I have downloaded our inventory database from Zohobooks to Excel. The inventory prices are reflected as currency eg EUR 10.00. However I cannot get this field to convert to a value. Please hel...
Try replacing "EUR " (without the quotes) with nothing.
Thanks Hans. I have 2000 + items that have downloaded. I cannot change each line item manually and I cannot figure out how to remove the EUR with a formula.