[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[_3_]]

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.

--
Stefan Blom
Microsoft Word MVP



"Connie Martin" wrote in message
...
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?

[Connie Martin]

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

"Stefan Blom" wrote:

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.

--
Stefan Blom
Microsoft Word MVP



"Connie Martin" wrote in message
...
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[_3_]]

Well, that certainly explains why the zeros disapperad. :-)

Thank you for the feedback.

--
Stefan Blom
Microsoft Word MVP




"Connie Martin" wrote:

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

"Stefan Blom" wrote:

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.

--
Stefan Blom
Microsoft Word MVP



"Connie Martin" wrote in message
...
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?


.