the problem arises when you're replacing a text with another text that excel thinks of as date, like 1/1.
you cant use format button in replace dialog-box because it first converts the text to date and then formats it as text that results in a strange number like 41640.
You can off course use formula but it is not always handy to do it.
I was wondering if anyone has any solutions for this?
sincerely...
Bookmarks