Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Numbers, how can I convert a number to negative.





In Excel, you can use tools like Paste Special, but these don't exist in Numbers.

share|improve this question
up vote 6 down vote accepted

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.

share|improve this answer

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).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.