Formatting a boolean value

To format a number as boolean:

  1. Select the Cells command from the Format menu (or right-click and select Format Cells).

  2. Select the Number tab in the "Format" dialog box.

  3. Select Boolean to display either TRUE, for all numbers that are non-zero, or FALSE, for cells containing zero.

Note that there are no options to choose from here – just selecting Boolean will ensure the above result.