| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert Numbers to Dates | Excel Discussion (Misc queries) | |||
| How do I auto-convert European dates to US dates? | Excel Worksheet Functions | |||
| Convert Numbers to Dates | Excel Worksheet Functions | |||
| Convert serial numbers to dates | Excel Worksheet Functions | |||
| FORMULA REQD FOR ADD ING DATES AND VALUES AND PART NUMBERS | Excel Discussion (Misc queries) | |||
Threaded Mode
