How do I remove the currency sign in a currency field?

Numbers 4.3 seems to insist that the results of STOCK, CURRENCY and similar functions be formatted as currency. When you multiply the results by a number (to convert them) the result of that calculation is also formatted as currency, and can't be changed. The only way to remove the Currency formatting so that you don't have unwanted currency symbols that clutter up your document seems to be to use the VALUE function, something like this:

Then you can then format the cell containing the VALUE function as Number, and multiply or divide it by numbers in cells that can be formatted as Number without the currency symbol..

This extra step is unfortunate. You can give feedback to Apple via Numbers > Provide Numbers Feedback.

SG

I guess the answer depends.

If the currency symbol is there in the cell because it was entered or already part of the text, then use search and replace to find the symbol and replace it with nothing

if the symbol is there because it was formatted as currency then format the cell as a number