3

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.

6

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.

| improve this answer | |
3

It would be awkward, might not be worth the time, but you would need to program this in automator using numbers hooks for automation / accessibility. That way you could make a service to swap the sign of whatever is selected.

Short term, you'd manually change each or set up a function to calculate the negative of the selection and then paste the values over the source.

This is one of the features that just isn't baked into Numbers (yet).

| improve this answer | |

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .