There are two other methods to use the DEC2BIN function in Excel. 1] Click the fx button ... A Function Arguments dialog box will open. In the Number section, input 1 into the box.

Luckily, Excel offers handy formulas that allow you to convert text into upper case, lower case, title case, and even ...