Prevent XL from reformatting when data copy/pasted

		Microsoft Office Forums > Microsoft Excel > Excel
Prevent XL from reformatting when data copy/pasted

FAQ

Thread Tools

Display Modes

05-08-2016, 11:29 PM

Pecoflyer

Windows 7 64bit Prevent XL from reformatting when data copy/pasted

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

One possibility is to format the entire destination sheet as "Text".

I think this will preserve all pasted data as is.

__________________
Using O365 v2503 - 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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Style for Text Changes from Normal to Heading 1 when Copy-Pasted	Basia	Word	8	08-15-2015 02:32 PM
Prevent access to raw data in a pivot table?	Chancy	Excel	3	02-03-2015 11:33 AM
Conditional Formatting over copied and pasted data	kb3264	Excel	6	07-11-2012 07:12 AM
Stop underlining pasted data	LarryStroup	PowerPoint	5	01-11-2012 12:47 PM
Numbered list turns to bullets when copy/pasted	cathleenmcguire	PowerPoint	6	08-31-2011 08:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:36 PM.