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.

Open Excel Online on your computer. Right-click on the date/time cell. Select the Number Format option. Switch to the Date tab. Select a date format you like. Click the OK button. Let’s check ...

To stop this automatic simplification, you need to tell Excel what denominator to use. In other words, to keep "4/6" as is, ...

If the numbers keep changing to dates in Microsoft Excel, you can use the following methods to fix the issue: Format cells as text. Insert an apostrophe before the number. Use Paste Special. 1 ...