formatting a cell in NUMBERS

In Numbers how do I remove the "CA" symbol in a cell for currency

MacBook Air, macOS 15.1

Posted on Jan 22, 2025 8:40 AM

Similar questions

how to get iphone Numbers to detect currency format of a cell? I need help with building formula for iPhone Numbers to change its output according to currency formatted in cell. this helps reduce additional columns and number of formulas
450 4
How can I change token currency in Numbers? Numbers, Cell / Data Format / Custom Format, how change token currency to a different currency. There is not anyway for me to change from £, I use different currencies on my spreadsheets. [Re-Titled by Moderator]
343 2
Automatic formatting for currencies When a cell is left on automatic formatting, the formatting will adapt to its content, and so will automatically change the currency of the cell to reflect the content. For example, if the cell contains a stock price it will change from $ to CA$ if the stock is listed on the Toronto Stock Exchange. However, any change to the formatting will nullify these automatic formatting advantages. For example: say cell A1 has a picker that allows me to choose from different currencies. B1 just says "$1 =", and C1 (set to automatic) will give me the exchange rate, correctly formatted with the currency selected in A1 so that when I change my selection the formatting of C1 changes to reflect the new currency. So far so good. But say I wanted to enable "Thousand Separators" or maybe add some decimals, then the formatting immediately switches to hardcode the current currency selection as the format of the cell, and changing A1 will no longer automatically switch the formatting of C1 to the correct currency. Is anyone aware of a way to adjust the formatting of currencies while retaining the automatic changing to the correct currency?
366 1

1 reply

SGIII

Level 8

37,920 points

Jan 22, 2025 7:21 PM in response to paulinaya

Is it displaying as CA$. If so, go to the Data Format dropdown under the Cell tab and change the Data Format from Currency to Number.

If it CA (perhaps in data you have imported) then you should change that at the source. Or a script might do the job.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

formatting a cell in NUMBERS

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up