Changing_units_without

With a worksheet displayed, select a column in the Columns tab that has defined units and press Units Builder.

In the Units Builder dialog, select the Specify Units option button.

In the New Units field, type the new unit.
Or
Use the Unit Components menus and the operator buttons to enter the unit.

Press OK.

The unit is changed without converting the values in the column.