Excel Help

Pasting "word" w/out losing the quotes

[eWhisper]

I just updated my Excel and forgot some of the custom settings I had in it.

Now, whenever I paste something like:
word
[word]
"word"

The output is:
word
[word]
word

and the "quotes" are lost.

How do I set excel to not lose these quotes? Even in paste special text cells which are suppose to be exact pastes, I lost the quotes.

Thanks for help on this one.

[Clark]

I just tried it and all of those paste ok

[eWhisper]

When I copy/paste from a webpage, it keeps the formatting.

It's when it's pasted from another program, text file, or web based text box that the quote formatting is lost.

[HughMungus]

Have you tried using "Paste Special" and pasting as unicode text?

[eWhisper]

I've tried all the paste specials, and cell types. I think in excel 2003 that putting something in quotes does a special formatting or it makes excel think its a specific formula - not sure.

[coopster]

After you paste it the Paste icon should show up. Click it and select "Use Text Import Wizard..." and you'll be able to keep your formatting.

[eWhisper]

Thanks coopster.

It's the 'text qualifier' that messes everything up as its ", and can be changed in the import wizard - is there anyway to change that setting permanently, or at least for an entire workbook for any one project?

[coopster]

Not that I'm aware of. By the way, OpenOffice (Calc) will allow you to paste this and won't change it on you at all, quotes stay intact.