Paste into Excel without Excel doing ANY re-formatting

macropod · #13 07-05-2016, 06:14 PM

Quote:

Originally Posted by macropod

There is nothing to turn off. Pasting dates results in then taking whatever the default date format is for your system.

Quote:

Originally Posted by Lebber

I want to be able to paste somethign like "24-7" as "24-7" and NOT transform it in any way. That's precisely the issue I have.

If you want to use another format, either paste them as values into pre-formatted cells (otherwise you'll just get serial #s)

Quote:

Originally Posted by Lebber

They will still be transformed. Not a solution.

Evidently, you've never heard of preformatting the destination as text... Content like '24-7' pasted from another application will remain '24-7'. Likewise, it seems you've never explored the 'Paste Special 'options, one of which is 'Keep source formatting'...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel: Copy and Paste into a Comment ?	ElisCom	Excel	2	02-17-2014 03:50 AM
Paste special an Excel range into Outlook as an Excel Worksheet	charlesh3	Excel Programming	3	02-04-2013 04:33 PM
Paste data in "Accounting"format from Excel into Word changes formatting	cory_0101	Word	4	10-17-2012 12:30 PM
Paste Excel Link As	tphillippe	PowerPoint	1	11-26-2009 05:54 PM
Paste chart from Excel	bielak01	Word	4	04-29-2009 02:42 PM