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?
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)
There are few ways to resolve that, the most common and simple one would be to format the cells prior pasting the data as text (select range, right click, format cells, double click on text).
What I have done was to simply change the decimal separator:
File -> options -> advanced -> untick "use system separators" and set the decimal separator to a dot "." (default in my case was the comma).
Check http://cloudishvps.com/windows/stop-excel-2013-auto-converting-numeric-values-dates/ for screenshots if needed.
The problem you have is that the field or the whole column is set to contain the data in a DATE FORMAT. To overcome this, a simple way is to select the field or the entire column, 'Right click' > Format Cells > Click Number (Select sub-options according to your requirement) > Press OK.
Hope this helps.
1.) try to add this sing (') in you number in source data then past it into excel the replace (') with same (') because when you add this sing it will be shown in your data in excel but when replace it with it will be hidden.
2.) If your typing then simply add this sign (') before your number then excel will not convert it into date and this sign will not be shown in your