part number with 'E'

C

chiuinggum

I copy a part number 0613952E01 and when paste it to excel it turn out to be
6.14E+06. It try to paste special it into text but it doesnt work. Appreciate
your help.
 
B

Bob Phillips

precede it with a single apostrophe '

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

Ron Rosenfeld

I copy a part number 0613952E01 and when paste it to excel it turn out to be
6.14E+06. It try to paste special it into text but it doesnt work. Appreciate
your help.
Click to expand...

Huh? I don't see a "paste special text" option on the edit menu in Excel 2002.
So I can't help you with that.

But if you format the cell as TEXT **before** you paste the value into it, you
should be able to execute and ordinary paste operation.




--ron
 
C

chiuinggum

yes if it only one part number i can always have a apostrope ' ...but in
actual case i have a list of 200 part number with 'E'
 
D

Dana DeLouis

Huh? I don't see a "paste special text" option on the edit menu in Excel
2002.
Click to expand...

Hi. I think the op is using "paste special" from a copy operation in a
non-Excel program.
If Excel is in Linking mode, (copied from within Excel) then paste special
pulls up it's own "Paste Special" window.
If copied from say "Notepad", then Paste special in Excel pulls up Windows
Paste Special, with limited capabilities.
From Notepad, I see Paste Special | Text (& Unicode text). If copied from
Wordpad, there are a few more options. :>)
 
R

Ron Rosenfeld

Hi. I think the op is using "paste special" from a copy operation in a
non-Excel program.
If Excel is in Linking mode, (copied from within Excel) then paste special
pulls up it's own "Paste Special" window.
If copied from say "Notepad", then Paste special in Excel pulls up Windows
Paste Special, with limited capabilities.
From Notepad, I see Paste Special | Text (& Unicode text). If copied from
Wordpad, there are a few more options. :>)
Click to expand...

OK, that's a possibility, depending on what he is doing. However,
pre-formatting the cells as TEXT should still solve his problem, I would think.


--ron
 
Top