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.

Excel spreadsheet databases work because users ... In this how-to, we’ll show you how to apply Date, Number, and Text filters to your spreadsheet. To make it easier for you to practice the ...

For example, the date format. In case you do not want to use the predefined date or time format, you can change ... in Excel Online. Then, right-click on the date/time cell and select the Number ...

As well as keeping your number as a fraction, this method automatically switches the cell's number format from General ... to ...