numbers change text cell to number cell when using find and replace
numbers change text cell to number cell when using find and replace
That's not what happens for me. If the number is in a cell formatted as text, it remains text after Find/Replace.
Before:
After replacing 1 with 6 (replace all):
Text is still text. Numbers are still numbers