Create a table or use an existing one. Type =DEC2BIN(A2, B2) into the cell you want to place the result. Then press the Enter key to see the result. To see the other results in the table, drag the ...
You can follow any one of these methods below to convert numbers stored as text to numbers in Microsoft Excel: Using the Text to column button Using Value function Changing the format Use Paste ...