auto Insert text ---- ' ----

[SharonInGa]

Does anyone have a macro that automatically inserts the --- ' ---- into a
column so that the field reads as a text field? Example: 123 reads as a
value, '123 reads as a text.

 

[Frank Kabel]

Hi
why not format the cell as 'Text' before entering values?