How to Convert Excel Field to Boolean Type

Techwalla may earn compensation through affiliate links in this story.
Excel stores truth values much as printed forms do.

You might have noticed that Excel doesn't appear to offer "Boolean" as cell type. When you try to format a cell, Excel will suggest formatting its contents as a currency, a date or time, a percentage but not a boolean value. Nonetheless, Excel does process boolean values and it regularly produces them as the output from formulas. To create a cell whose boolean value you change, create a checkbox. When checked, this box will have the value of "True." When unchecked, it will have the value of "False."

Advertisement

Step 1

Click "File."

Video of the Day

Step 2

Click "Options." This opens the "Excel Options" window.

Step 3

Click "Customize ribbon."

Step 4

Check the box next to "Developer" in the pane on the right. Click "OK."

Step 5

Click "Developer" from the menu bar.

Advertisement

Step 6

Click "Insert" from the "Controls" tab.

Step 7

Click the icon for a check box from the "form options" section.

Step 8

Click on the cell to which you want the add the boolean value.

Advertisement

references & resources