Benches Uncategorized

2

Make several numbers negative?

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Ist there a way to select several cells (say a column) containing numbers that have been entered positive and invert them so they all get negative?

This sounds like a very basic task to me, and maybe I am just too dumb to find the button. Or do I have to take the detour via some calculation?

Many thanks in advance!

2 replies

Sign in or join Beachball Help to reply.

  1. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Not that I know of.

    You can create a second column with the formula =-B in each cell (assuming your original column is column B). You can either use that column or you can copy it and "paste values" back to your original column then delete this column.

    If you simply want the numbers to look negative on the screen (but not actually be negative), you can create a custom format to do so. Personally I'd avoid this.

  2. 0

    dk215

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Many thanks, that's an easy method. Also learned about the "Paste values" feature this way.

    Problem solved 🙂