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.

Microsoft Excel multiplies each cell by 1, and in doing so, converts the text to numbers. We hope this tutorial helps you understand how to convert numbers stored as text to numbers in Excel.

Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.

Excel has several custom formatting options for duration of time, and it will recognize most times you enter, provided you use a colon between the hours, minutes and seconds.

Navigate to the "Number" group within the "Home" tab in Excel. Click the small arrow beside the "Number Format" box. Click "Text" to convert your cells to text formatting.

Convert to currency. This option will left-align the dollar symbol and right-align the number. Technically, this is referred to as Accounting formatting.