This has been a problem for as long as I have used Excel (years and years and years). Many times when I copy/paste numbers into Excel, the program will autoconvert the number to a date to something like May-99 and the actually value in the cell is changed as well to like 05/05/1999 ... how to keep it from autoconverting? As well as the autoconverting to scientific notation. This refers to my previous question about validating serial numbers in another post. I might have a serial number I am copy/pasting into a spreadsheet like 39579312003003 ... that will be autoconverted to scientific notation. annoying.

Thanks.