Unit Formats

Apply unit formats to cells

Overview

Easily format cells to display units of measure eg: kg, lb

Example File

The videos and usage scenarios on this page make use of this file, which you can download.

Steps

1. Select the cell(s) that you want to apply the format to.

2. Click the 'Unit formats' dropdown button.

3. Choose and click the unit to apply.

To add new units of measure:

1. Click the 'Unit formats' dropdown button.

2. Click 'Add/edit unit formats'

3. Enter your format text. Click the 'Insert superscript' button to insert various superscripts.