Forum Discussion

tonyhTonyh199's avatar
tonyhTonyh199
Copper Contributor
Nov 06, 2022

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...
excel
Formulas and Functions
tonyhTonyh199's avatar
tonyhTonyh199
Copper Contributor
Nov 06, 2022
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

mathetes's avatar
mathetes
Silver Contributor
Nov 06, 2022

tonyhTonyh199 

I have tried your formula but it returns a #VALUE! message

 

 

Not sure what to say, other than that I could not reproduce your #VALUE error message. I tried to add in other (blank) spaces in the text, but the formula still worked. And when I copied your more compete set of  examples, and then just copied the original formula down to the remaining adjacent cells, it converted them all without error.

 

Given Microsoft's description of how to correct for a #VALUE message, there are a couple of things you should check. 

 

 

Did you copy the formula from my sample worksheet, or re-enter it? And were you putting the formula (edited appropriately to refer to the correct column) into a column adjacent to the problem cells?

 

I've reattached with the more extensive set of raw data.

 

There also may be something about the way your text fields are formatted... Is it possible for you to post a copy of your spreadsheet on OneDrive or GoogleDrive, granting us access via a link posted here?

 

 

Resources