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.

changing column of negative numbers to positive

How do you change a column of negative numbers to positive in Numbers

MacBook Pro 15″, macOS 11.7

Posted on Jan 26, 2024 12:29 PM

Top-ranking reply

Yellowbox

Level 7

22,545 points

Posted on Jan 26, 2024 7:38 PM

Hi Robert,

To convert all negative numbers in a column to positive numbers, the ABS function is your friend.

Formula in B2 is ABS(A2)

Fill down.

That converts every value to positive.

From the Function Chooser,

Regards,

Ian.

View in context

Similar questions

2 replies

Top-ranking reply

Yellowbox

Level 7

22,545 points

Jan 26, 2024 7:38 PM in response to Robert Palumbo

Hi Robert,

To convert all negative numbers in a column to positive numbers, the ABS function is your friend.

Formula in B2 is ABS(A2)

Fill down.

That converts every value to positive.

From the Function Chooser,

Regards,

Ian.

Badunit

Level 7

31,549 points

Jan 26, 2024 12:53 PM in response to Robert Palumbo

You can also do it this way: insert a new column, put into each cell a formula that multiplies the original column by -1, copy the results, Paste Formula Results back to the original column, then delete the temporary column.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

changing column of negative numbers to positive