How to Convert Excel Field to Boolean Type

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
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."

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.


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.

Video of the Day



references & resources

Report an Issue

screenshot of the current page

Screenshot loading...