Contextures

Excel Data Problem Pasting

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.

  • 3/4
  • 02345
  • 1-3

 

Related Links

Sample Data (for testing)

More Sample Files

Excel Topics

Don't Miss Our Excel Tips

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.

Get weekly Excel tips from Debra

 

 

Last updated: December 7, 2020 11:19 AM