The above-mentioned steps help you change the date or time format for a ... open a spreadsheet in Excel Online. Then, right-click on the date/time cell and select the Number Format option ...

Using Excel's number format tool means you can ensure your spreadsheet both looks the part and handles your data exactly how ...

Pro tip: Never change the format of a cell with a date to General or Text. Excel will turn your date into an unrelated number. For example, 3/3/2017 becomes 42797 when it's not formatted as a date.