The DEC2BIN function in Microsoft Excel is an Engineering function, and its purpose is to convert a decimal number to binary. The formula for the DEC2BIN is DEC2BIN( Number, [Places]).

Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

SEE: 83 Excel tips every user should master (TechRepublic) In this Microsoft Excel tutorial, I’ll show you four easy ways to convert numbers stored as text to real numbers.