How to Convert the True and False Values to 1 and 0 in MS Excel
- George Apostolov
This guide is an interactive LiveDemo. Create interactive demos of your own product: Interactive demo software · Interactive customer onboarding guides · Start free
How to Convert the True and False Values to 1 and 0 in MS Excel: step-by-step guide
Inside your Microsoft Excel worksheet, select the cell that contains the true and false values you wish to edit.
After that, head over to the ribbon section and click the formula bar.
Enclose the formula in parentheses as shown in the example: (N3>5000).
Subsequently, add two dash lines (-) next to the equals sign. Follow this format: '=--(N3>5000)'. Once done, press the enter key to run the newly revised formula.
After completing these steps, the true and false values from the selected cells will be converted to 1 or 0.
Quick answer: To convert true and false values to 1 and 0 in Microsoft Excel, select the target cell, click the formula bar, and enclose your formula in parentheses. Next, add a double dash before the equals sign to form an expression like =--(N3>5000), then press enter to run the revised formula.
About this Excel tutorial
Convert True and False values to 1 and 0 in Excel by editing your formula with a double dash. Follow these quick steps for instant results. This guide shows how to convert the True and False Values to 1 and 0 in MS Excel in 5 steps, starting with "Inside your Microsoft Excel worksheet, select the cell that contains the true and false..." and finishing with "After completing these steps, the true and false values from the selected cells will be...". The interactive demo above is a click-through copy of the real Excel interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to convert the True and False Values to 1 and 0 in MS Excel?
5 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Excel data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Excel. Related guides: How to Copy and Paste Cell Content in Microsoft Excel, How to copy conditional formatting microsoft excel and How to Copy Formulas Microsoft Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
