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.
 
Highlight the column where the date is going, right click, format cells, go
to the number tab and choose the format you would like the date in.
 
At last another punter !
Lookup "numbers contain hyphens(norman jones)"
in excel.programming , you will find what you are
looking for.Norman has a macro that works perfect.
I'm using it my self

regards Bill Gras
 

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? 3
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