Stop auto date formating

[doriannjeshi]

Hello, I need help with a long column that I need to substitute a character . with - in each cell but for some cells it applies the date format and messes up the outcome. I ve tried everything,

 

[Joe4]

Yes, if you are using Find/Replace, it will do that.
You can do what you want using a formula instead, i.e.

=SUBSTITUTE(A1,".","-")