How to Convert Excel Field to Boolean Type

1. Click 'File.'
2. Click 'Options.' This opens the 'Excel Options' window.
3. Click 'Customize ribbon.'
4. Check the box next to 'Developer' in the pane on the right. Click 'OK.'
5. Click 'Developer' from the menu bar.
6. Click 'Insert' from the 'Controls' tab.
7. Click the icon for a check box from the 'form options' section.
8. Click on the cell to which you want the add the boolean value.