When I do a find and replace, the find function works find but the replace is not working. When I click on replace the data in the cell does not change. When I use replace all I receive the message that X number of replacements were made but the data in the cells remains the same.



I have all the cells formatted as text because I am working with numbers that I want to be seen as text.

Any ideas on how to correct this?