Forum Discussion
Numbers automatically formats to Date
Worksheet compatibility issues
In this article
It could be a lot, from regional settings to the fact that the worksheet is from an earlier version and this leads to compatibility problems.
It is best to send the file (without sensitive data) to see exactly where the error could be.
Knowing the Excel version as well as the operating system would be an advantage for everyone.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
NikolinoDE Thank you for your response. I have attached a sheet for your reference. I changed the format for column A to display '01-02', however when I try to filter, it is still showing as complete date.
Stop automatically changing numbers to dates
If you only have a few numbers to enter, you can stop Excel from changing them into dates by entering:
A space before you enter a number. The space remains in the cell after you press Enter. (See Notes)
An apostrophe (‘) before you enter a number, such as ’11-53 or ‘1/47. The apostrophe isn’t displayed in the cell after you press Enter.
A zero and a space before you enter a fraction such as 1/2 or 3/4 so that they don’t change to 2-Jan or 4-Mar, for example. Type 0 1/2 or 0 3/4. The zero doesn’t remain in the cell after you press Enter, and the cell becomes the Fraction number type.
Nikolino
I know I don't know anything (Socrates)