In Numbers, how can I convert a number to negative.
E.g.
200
233
186
Becomes
-200
-233
-186
In Excel, you can use tools like Paste Special, but these don't exist in Numbers.
Numbers: Make numbers negative
numbers
Related Solutions
You need to use the $ char e.g. like this: =$D$3
Numbers seems to use the decimal separator selected in System Preferences:
I didn't find any way to use both comma and period as decimal separators though.
Note that if you change the region from the menu at the top, it also affects things like the default values of locale variables in Terminal and iTerm.
Related Question
- Using last column in Numbers
- Is it possible to swap two cells content in numbers
- In Numbers can you auto-populate a cell with a date when another cell is populated
- MacOS – Make chart series rise when number of rows rise
- Naming a Cell in Numbers
- How to import text to columns and import numbers to text in macOS Numbers
Best Answer
A workaround is to create a column with formulas like "=-1 * A1", then copy and "Paste Formula Results" (⇧⌘V). But I'm sure there are better solutions.