replace all

  • Thread starter Thread starter inprogress
  • Start date Start date
I

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
 
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.
 
Back
Top