Im a column I have entries as follows:

6-16

5-10

2-14

I want to replace the "-" with "/"

When I go ahead and replace then using CTRL + H  method;  The replacement will also calculate a decimal number (42491) or put a date like entry (05/06/2009).

All I want is the cell to show 6/16 instead of 6-16.

I have changed the cell format to text and also have set the calculation to manual, but still keep having the same behaviour.

Any tips on how to do it? I'd really appreciate it.