Thread: [Solved] Paste into Excel without Excel doing ANY re-formatting
View Single Post
 
Old 07-07-2016, 11:54 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,385
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
I confirmed the correct behaviour with Excel 2010 before posting. Correctly installed, Excel 2010 works as specified. If you're not getting the correct results, that suggests your installation(s) are at fault, regardless of how many you might claim to have tested with - or that you're not telling us the whole story...

Update: The problem with the data in your link (I've just found your earlier discussion and moved this one back to your own thread instead of leaving it in the one you hijacked) is that you're trying to paste many different data formats at once and Excel has to make its best guess as to how each item should be handled. Sometimes it comes up short and you need to do some minor reformatting. Not really a big deal, though you could write a macro to do it if the issue was critical. Given your attitude though, don't expect any help from me on that front!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]