Want to avoid pasted text becoming dates

  • Thread starter Thread starter GeorgeB
  • Start date Start date
G

GeorgeB

Occasionally, I will paste from a table arrangement on a website.
Sometimes, this data will contain text that has some characteristics
of a date, eg, 3/16 as a fraction.

I could live with it becoming 0.1875, but not March 16, 2005. How can
I prevent Excel's intelligence from overcoming my stupidity <g>.

TIA, George
 
One work-around is to paste into notepad.
Save that file as *.txt

Then open that text file in excel. You'll be prompted by the text import wizard
for how you want each field.
 
One work-around is to paste into notepad.
Save that file as *.txt

Then open that text file in excel. You'll be prompted by the text import wizard
for how you want each field.
Click to expand...

That sounds good; I'll give it a try. The only problem will be in
figuring out the delimiters, but tab characters will probably be
insertrd, making it easy. Thanks!
 
Back
Top