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

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