View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
The Blue Max The Blue Max is offline
external usenet poster
 
Posts: 9
Default opening excel file in 2007

I also sometimes DO NOT WANT the auto format assumptions made by
Office when I cut and paste text from somewhere else. I hate having to paste
in to notepad so I get back my "paste special" function to drop the text in
as unformated. Sometimes all the "extra value" that gets added is a
hinderance not a help.


Hello, Chris. I think there may be an easier solution than pasting and
copying from Windows Notepad. Perhaps when you have pasted something into a
Microsoft application and have noticed a little icon that appears next to the
pasted block? If you click on this icon you will be presented with a
drop-down menu and I believe that these options will address your concern.
The options allow you to apply either the source or destination formatting to
the pasted block. Hope this helps.

By the way, thanks for the detail on disabling Norton AntiVirus in Excel so
that we can load our documents. There are a ton of postings relating to this
issue, unfortunately the word is not getting back to all of the posters. Too
bad the newsgroup server cannot automatically match and link relevant threads
to a newly posted question!