Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.

Please note: This item is from our archives and was published in 2001. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I often need to ...

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 ...