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.

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.

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.

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