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.
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.
spreadsheet with column containing several hundred rows of negative numbers, is there a way to convert them to positive numbers
[Re-Titled by Moderator]
MacBook Pro 13″, macOS 15.2
Hi Johnny,
If all values are negative,
Formula in C2 is −B2
Fill down.
If values are some negative and some positive, we need an IF statement:
IF(B2<0,−B2,B2)
Regards,
Ian.
thank you
Converting negative numbers to positive in a spreadsheet column
