If you copy numbers such as 1-4 or 3/5 and paste them into Excel, they will usually change to dates.
For example, copy the numbers below, and paste them onto a worksheet, to see how Excel adjusts them.
Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.
Last updated: December 7, 2020 11:19 AM