Warnings Excel will only produce binary numbers with up to 10 bits. This means that it can only convert decimal numbers greater than -513 and less than 512.

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.

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.