View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Local_IT Local_IT is offline
external usenet poster
 
Posts: 1
Default part numbers auto-convert to dates

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