I have a list of cells that I'm searching for the value: !5-10 , and I want to replace all of them (100+) with the value 5-10, essentially just dropping the "!". When I use Find and Replace to do this en masse, it finds the target value just fine, but it changes it to "41769", even when the cell format is set to text.

Incidentally, if I do it manually and delete the "!" in each cell, it shows up as desired.

Why won't it do this automatically and how can I fix that?

Thanks,
mb