Hi Rob,

I thought this might do the trick, but it didn't seem to
work. I may have done something wrong.

First, I clicked the upper left cell border, to select
all cells, and right clicked to format the cells
to "text". I then pasted the HTML from the clipboard
into the worksheet.

Unfortunately, the darn cells still covert to dates! I'm
assuming the pasting of the HTML overrides my formatting?

-----Original Message-----
Hi Russell,

The simplest thing to do would be to format the
entire target worksheet
with a text format prior to pasting in the HTML data.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Russell L." wrote in message
...
Hello,

I have been creating a process where I paste raw HTML
into a worksheet, and then programmatically extracting
the necessary data from the cells. For the most part,
the data copies to cells with little issue.

However, any cell values that appears in the
format "xx-
yyy", where xx or yyy is in the range of 0 to 12
numeric,
will automatically be converted to date.

I want to know if it's possible to stop Excel from
converting any values in the data pasted. In other
words, I want no automatic conversion of any cell
values
when I paste the HTML to the worksheet.

Any ideas? Thanks!!!

Russell Longo


.