It depends on the data types, I suppose.

If you format a column as Text and place a numeric value in it then it will not
change it. Also, if you formatted a numeric column and added text then you
would be ok too.