Prevent format change caused by pasting. (office '97)

A

a.polybius

Every time I paste something that was from an website (even if only
one word) the column extends as far right as it allows. I found out
that I can change the format (under paste special) back to text to fix
this.

Is there a way to prevent excel for changing format? I want it to
default as text format and not change format unless I change it
myself. Also is there a way to keep the text at one font and one text
size, so that if I paste something that had a different size or font
it would change to the size and font that I have set for my document
(I want to know how to do this in Word as well.)

Btw I'm using Office '97, I know it's an older version, and I
apologize if this is something that never versions don't have an issue
with.

P.S. If you are just going to tell me to use an search engine to find
answer, please don't bother.
 
G

Gord Dibben

Paste Special>Text is one way as you have found out.

Bringing in the data as Data>Import External Data>New Web Query gives you some
options to format before the data is brought over, but not to preserve your
current formatting AFAIK.

Later versions have not made this any easier and it still an issue.


Gord Dibben MS Excel MVP
 
Top