Stop excel from converting copy-pasted number/text values to date

This is definately a kluge and it's the only thing I've figured out to do. I came here looking for a more elegant solution.

I do have a slight improvement for this.

1. Paste the data into the spreadsheet as is.
2. Select all and format as text
3. Paste again over what you did the first time but this time as values.

This keeps you from having to count columns and rows, etc.

If you have data you actually want to be numbers, dates, etc, it's much easier to reformat them correctly from this end than it is to do from the other. Since the numbers won't automatically convert, I used text to columns on the column, selecting "delimited" but unchecking all the delimiters. This has the same effect as going into each cell and hitting enter to get Excel to recognize it again. Ugly, but it works.

The Most simple way.

1. Copy the original Data
2. Paste to Notepad (Prefer Notepad++)
3. Change the Cell Properties to TEXT
4. Copy All from Notepad
5. Paste back to Excel.

1. Open a Blank Workbook
2. Click on Data
3. Click From Text
4. Locate your CSV/txt file
5. Click Next
6. Choose your Delimiter
7. Click Next
8. Use the scroll bar to locate the column you wish to protect and click on it
9. Select Text from the Column data format
10. Click Finish
11. Click OK

The data will now have been imported without the date conversion.

Try this, it worked out for me:

Data - Import external data - New web query and follow the wizard

It's so simple.

regards!