How to stop numbers converting to date format on copy paste in Excel?
Fresh3 days ago
Mar 15, 202641640 viewsConfidence Score0%
0%
Problem
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?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to stop numbers converting to date format on copy paste in Excel?
Low Risk
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…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix