Disable Date Recognition

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.
 
C

Christene

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.
 
B

bill gras

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
Date Formats 4
.. any help appreciated .. i think it's a pasting HTML problem. 1
Import Data Problem 1
Look Up Formula With Veried Search Range 2
Data being corrupted by excels automatic date recognition re-forma 6
Copy unformatted value of cell via macro 0

Top