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
|