replace all

[inprogress]

i am trying all cells with a "-" with a " ". however when i do this i
also replaces all negative numbers as well. For example: -1345 is no
1345. how can i avoid this? thanks

 

[Dave Peterson]

Be more careful with your selection???

Or select your range.
edit|goto|special
check constants
then uncheck all but text

If you only have one cell left, don't do a Replace all. But if you have
multiple cells left in your selection, your edit|replace will only affect those
selected cells.