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...
Does the field appear literally as "EUR 10.00"? And are all of the currencies Euros?
If that is the case, a simple formula can convert the numeric portion to value and the formatting as currency can display it as desired. I've attached a demo spreadsheet. But here's the formula
=VALUE(RIGHT(A1,LEN(A1)-4))
Thanks Mathetes,
This is how the amounts appear:
EUR 147.00
EUR 94.10
EUR 168.27
EUR 1.65
EUR 21.70
I have tried your formula but it returns a #VALUE! message
This is how the amounts appear:
EUR 147.00
EUR 94.10
EUR 168.27
EUR 1.65
EUR 21.70
I have tried your formula but it returns a #VALUE! message