How to Convert Excel Field to Boolean Type

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."

Step 1

Click "File."

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.

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.

references & resources