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.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

And because Excel recalculates formulas every time you press the Enter key and every time you save and exit, the numbers will never be saved anywhere. NOTE: RAND numbers are between 0 and 1.