Forum Discussion

Jeevitha_S's avatar
Jeevitha_S
Copper Contributor
Jun 08, 2021

Numbers automatically formats to Date

How to stop the auto formating of number, eg - 02-02 to date?. I'm aware I can change the format or use apostrophes while typing, however while using filter it is still
excel
Formulas and Functions
Jeevitha_S's avatar
Jeevitha_S
Copper Contributor
Jun 14, 2021

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. 

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jun 14, 2021

Jeevitha_S 

 

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)

Resources