adriano's blog
Replace easy question
Submitted by adriano on 17 September, 2009 - 13:17Im 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.
»
- 2 comments
- Read more
- 3803 reads
Recent comments
5 years 27 weeks ago
6 years 13 weeks ago
6 years 25 weeks ago
6 years 28 weeks ago
6 years 29 weeks ago
6 years 34 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago