There is no silver bullet on that one. What is actually stored is 12345678 so
that is what is copied. The CN and S10 are just formatting. Short of copying
the cell formatting where the extra characters are stored you are hooped...
--
HTH...

Jim Thomlinson


"jimqual7" wrote:

nope, that doesn't work

"Mike H" wrote:

Try

Edit|Pastespecial
select ALL
OK

Mike

"jimqual7" wrote:

I have formatted cells as follows "CN"00000000"S10" so that when I type in a
serial number such as 12345678 it appears in the cell as CN12345678S10.
How can I copy the contents as it appears in the the formatted cell and
paste the "as displayed value" into another cell without formatting the
destination cell?
In effect pasting the value CN12345678S10 into another cell.