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.

Learn how to format numbers in Thousands, Millions, and Billions in Excel and Google Sheets. Use number Formatting to convert numbers.

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.

Similarly, it's easy to forget to type the currency symbol when you're focusing on the numbers that follow, so using Excel's built-in number format converter is the way forward.

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