When I copy data from a site and paste in Excel,
some numbers / numeric strings are converting to date format.
For example: "2-1" converting to "1-Feb".
How can I prevent this?
I have too many records to do manually.
Is there any quick process?
Excel – How to stop numbers converting to date format on copy paste in Excel
copy/pastemicrosoft-excel-2007
Best Answer
Select the empty fields (or the entire column), set them to a string format instead of the default value, and do a special paste (available on right-click) with "values only" to prevent a date format from being auto-applied.
(Moving Victor's comment to an answer, as per MSO, as OP and Victor haven't done so in a week)