Stop excel auto formating dates!

[doriannjeshi]

Hello,

Is there a way to stop excel stop converting 10-5 , 7-5 etc to dates like 5-Oct , 5-May

And if it got converted to date how to revert back to normal format

Thank you!

 

[Joe4]

Pre-format the column to "Text" before entering the value in the cell, and it will not convert it to a date.

To convert existing ones back, you can use this formula:

=TEXT(A1,"m-d")

 

[doriannjeshi]

Thank you for the solution!
To be more specific in a column I need also to have the conversion back hapen only to dates not regular numbers like 9 , 2 etc

 

[Joe4]

To be more specific in a column I need also to have the conversion back hapen only to dates not regular numbers like 9 , 2 etc

The issue is that Excel actually stores dates as number (specifically, the number of days since 1/0/1900).
So dates are really just numbers in Excel with special date formats.

However, actual numbers will probably be low, while "date" numbers will be high (enter any date in an Excel cell and change the format to General to see it as Excel does).
So, maybe check for high numbers, i.e.

=IF(A1>40000,TEXT(A1,"m-d"),TEXT(A1,"0"))

 

[doriannjeshi]

Yes, it's working thank you!

 

[Joe4]

You are welcome.