Disable Date Recognition?

  • Thread starter Thread starter Saxman
  • Start date Start date
S

Saxman

Is there any way within Excel whereby I can disable date recognition? I
often copy data from an HTML page and paste it into Excel. Even if I
select 'paste special'/'text', I still have problem with data like
10-12, and 5/6.

I can overcome this by importing data/new web query/options/disable date
recognition, but it appears to be a bit long-winded compared to copy/paste.

Thanks.
 
If you select (highlight) the columns into which you are pasting, and
Format Cells, set format to TEXT, and then Paste Special, Text your
cricket scores should remain intact.
 
Bryan said:
If you select (highlight) the columns into which you are pasting, and
Format Cells, set format to TEXT, and then Paste Special, Text your
cricket scores should remain intact.
Click to expand...

I tried this yesterday without success and today it works fine! I must
have been doing something wrong!

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable Date Recognition 2
howto: disable date recognition? 0
Import Data Problem 1
How to Disable date recognition 1
Data being corrupted by excels automatic date recognition re-forma 6
Web Query Pulling Date Incorrectly. 1
part numbers auto-convert to dates 4
Date format shows on formula bar, 5 digit numbers show in row 1

Back
Top