Cells keep insisitng on showing as dates

[therock003]

I have set a table to store some data and in one column i store proeuct codes. Weirdly enough the formar code is XX-XX-XX where xx is a number from 00-99. As you can imagine some get recognised as dates by excel. For example 35-42-67 is not an acceptable input for date, but lets say an item had the product code of 10-10-03 which coincidentally is the date equivalent of 10 october of 2003. I have of course gone to cell formatring and turn this entire column to text input or other formata but still the exclamation pops up that its a suspicious entry and thus when i sort this column everything gets messed up. Have you got any solutions for this

 

[jasonb75]

Try formatting the entire column as text (excel column, not just the table). I don't think it will make any difference with existing codes, but I did notice that if the cells below the table were formatted as 'general' then a new line added at the bottom was not entering correctly.

 

[therock003]

Tried that, also didnt work. Dont know man maybe its an excel bug. I'm on 2016 on Windows. I also tried on my android phone using excel mobile, and surprisingly it works fine over there...

 

[therock003]

Something fishy is definitely going on. I even tried libre office and it works there fine. For some reason my version of excel is hung up on this