numbers app not wanting to do a currencyconvert

> as you can see it will not allow me to type in USD I can only tape the U and then it is giving me the options in the photo

Ah, that explains it. You're doing it wrong :)

The target currency is required to be a string value. Therefore you need to quote the string => "USD"

Without the quotes, Numbers assumes you're trying to use a function that returns the target currency, and is (helpfully?) suggesting functions that begin with U

To be fair, and in Apple Support's defense, it wasn't clear me (or SGIII, apparently) from the original description, nor the original screenshots what the problem was.

It didn't click for me until that last piece where you showed it suggesting functions that begin with "U", and I realized what it was doing.

The Function Browser in Numbers does have an example where it shows the quoted target currency code:

but it is subtle.

The main thing to remember is that the currency code could be the result of another function or cell reference, so Numbers needs you to quote the currency code, just like you would for any other function where you want a direct text value rather than a lookup/calculation.

You're missing important details in your post.

First up, you say "... it will not let me tape in USD as the currency code", but I don't see that. Nothing in the images indicates that you cannot enter 'USD', only that you haven't yet.

Secondly, what is the cell format for B2? Is that a currency cell (I'm not familiar with R xxx,xx as a currency, so this may just be me)

Third, what happens when you try?

If there's an error, Numbers will generally put a warning triangle on the cell and hovering over the cell will give you some idea as to what the problem is. Knowing that error message will go a long way in troubleshooting this.

I may be missing something, but it appears that one of the formulas is referring to G3, but G3 seems to be blank. Could that be the problem?

SG