Thread: Cell formatting when pasting from a non-Office application
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Cell formatting when pasting from a non-Office application
Copy a range
Right clickPasteSpecialAll

OR

Right clickPasteSpecialFormatsOK followed by PasteSpecialValuesOK.


If this post helps click Yes
---------------
Jacob Skaria


"Nancy S" wrote:

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
Reply With QuoteReply With Quote