The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
How can I get rid of the minus sign without using a formula on the Numbers App for Mac? Every time I use a formula and try to delete the original column, it deletes the positive column.
MacBook Pro 13″, macOS 11.7
Or select the cells and multiply by -1 using this Multiply Values in Cells by Number Shortcut.
To inspect and, if you like, install the Shortcut click on the above link in Safari. It contains a small AppleScript.
You can run it by selecting the cells, selecting it from the Menu Bar, and answering the prompt.
As with many scripts that change the contents of a document you would be wise make a backup of your work before trying it.
SG
Or select the cells and multiply by -1 using this Multiply Values in Cells by Number Shortcut.
To inspect and, if you like, install the Shortcut click on the above link in Safari. It contains a small AppleScript.
You can run it by selecting the cells, selecting it from the Menu Bar, and answering the prompt.
As with many scripts that change the contents of a document you would be wise make a backup of your work before trying it.
SG
Hi cmgibson1986,
Select the column containing the formulas. Copy. Then Menu > Edit > Paste Formula Results. Then you can delete the original column.
Regards,
Ian.
Changing a Negative to a positive without using a formula in Numbers Mac App
