How it works

These functions allow manipulate numbers within a selection of cells to either convert between text numbers and numbers or convert between negatives and positives or convert them to absolute values.

How to use it:

Step 1

Highlight/Select the cells to be manipulated.

Step 2

In the ‘More’ drop down of the Formatting and Grooming group, click on the number manipulation function to be performed.

Step 3

On completion, the numbers will be converted as specified.

Scroll to Top