"Replace All" Cancels Formatting

[Connie Martin]

I have formatted a column to text. Currently in the column is a list copy
and pasted from MAS 500. Contents of each cell look something like this:
SO-0000001016. With the column formatted as text, I did Edit/Replace,
replacing SO- with nothing, intending to remove simply the SO- and leave the
six zeros. However, it wipes out the six zeros, as well, leaving simply
1016. If I manually remove SO- on every number, the six zeros remain. What
gives?

 

[Stefan Blom]

What you are describing shouldn't happen in Word. If, by any chance, you are
performing a Find & Replace within an embedded Excel spreadsheet, cell
formatting could be the cause.

 

[Connie Martin]

My apologies! I posted in the wrong group. Yes, this is Excel. I will post
there.

 

[Stefan Blom]

Well, that certainly explains why the zeros disapperad.

Thank you for the feedback.