Cell formatting when pasting from a non-Office application

N

Nancy S

Are you able to change a setting in Excel so that any copied text, numbers
maintain the formatting in the destination file (versus the originating -
copied from - file)?
I know you can do this in Word, but can't find it in Excel.
Thanks
 
J

Jacob Skaria

Copy a range
Right click>PasteSpecial>All

OR

Right click>PasteSpecial>Formats>OK followed by PasteSpecial>Values>OK.


If this post helps click Yes
 
J

Jacob Skaria

For ***Non-Office application ***

PasteSpecial>Text.. once copied try...Data>Text to Columns...


Most of the time what i do is copy this to a text editor such as NotePad and
then copy that to excel...so that excel assumes text and numbers..

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Text To Numbers ? 1
protect cell formatting 3
formatting when pasting into excel 1
Excel 2007 - A Conditional Formatting ?'s 1
Prevent invalid data when pasting from Word directly onto cell? 3
Prevent paste from re-formatting cell 4
Formatting not protected when paste 7
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Top