Give this a try:

Do a Paste SpecialText.
Then, click the Paste Option button (the little button that appears near the
bottom of whatever you pasted) and choose Open Text Import Wizard.
Click Next through the first two screens.
On the third screen of the Wizard, under Column data format, seelct Text.
Click Finish.

Hope it helps

ERR


"Local_IT" wrote:

What type of file are you pasting them from?

I had no trouble when I created the same data in Excel, then pasted it all
over the document. The source of the part numbers has to be the issue.

"Tmonster" wrote:

I have a long list of part numbers in XXXX-XX-XX format. When I paste them
into Excel, they are converted to dates XX/XX/XXXX and timestamp integer; the
numbers are lost. How can I disable excel's auto-conversion?

The solution listed on this site is not an option for me. I can't spend an
hour every day configuring file imports.


Try pasting this short list of part numbers into excel and watch what
happens...
4192-3-01
4192-3-02
4192-3-03
4192-3-04
4192-3-05
4192-3-06
4192-3-07
4192-3-08
4192-3-09
4192-3-10
4192-3-11
4192-3-12