#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Hi
have you tried formatting first as General?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Hi..yes I tried that too, but it didn't work either.
thanks |
|
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 |