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.
tonyhTonyh199 wrote:
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.You can replace in one go:
- Select the entire range with amounts in EUR.
- Press Ctrl+H to activate the Replace dialog.
- Type EUR followed by a space in the Find what box.
- Leave the Replace with box empty.
- Click Replace All.