Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-13-2017, 02:08 AM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Nov 2016
Posts: 72
ewso is on a distinguished road
Default pasting changes numbers into dates

When I copy text from the internet and paste it into excel, it changes the numbers I have copied into dates. i have tried selecting all the cells in my worksheet and formatting them to text before pasting, but every time I paste, it still changes the numbers into dates. i don't want dates. how can I fix this stupid behavior?



thanks
Reply With Quote
  #2  
Old 09-13-2017, 03:53 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,910
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Hi
have you tried formatting first as General?
Reply With Quote
  #3  
Old 09-13-2017, 04:09 AM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Nov 2016
Posts: 72
ewso is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
Hi
have you tried formatting first as General?
Hi..yes I tried that too, but it didn't work either.
thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Excel to recognize week numbers based on specific dates Ktyler Excel 5 02-06-2017 11:08 AM
Autofill dates - how can I get the same date and consecutive dates? Exhale Excel 3 04-05-2016 03:11 AM
How to keep the footnote(endnote) reference numbers when pasting text between two documents? gn4619 Word 4 10-22-2015 08:01 AM
displaying start and finish times as absolute numbers instead of dates benson.wallace Project 2 12-05-2010 07:22 AM
Pasting numbers: Darren Word 0 04-01-2009 11:22 AM


All times are GMT -7. The time now is 07:32 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft