Why isn't Numbers Portfolio Template accepting my 'My Price Paid' value of US$45.32?
it will not take the value of US$45.32
[Re-Titled by Moderator]
Well, without more info, your formula is invalid.
CURRENCYCONVERT() takes two parameters, a value, and a currency code.
You're passing in one parameter (60 / Price Paid in US dollars HOOD) plus some random digits that Numbers has no idea what to do with.
Without knowing what you expect this cell to do it's hard to be precise as to what to change. From the title (Price Paid), I'd assume this is a fixed value field, no? so why the CURRENCYCONVERT(), and why no currency code to convert to?