Stopping Excel from converting copied text data!
 

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


.

Stopping Excel from converting copied text data!
 

Hi Russell,

It sounds like you did what I suggested. Strange that it doesn't work. I
think it's an example of Excel being too smart for its own good and trying
to interpret the HTML on the clipboard rather than follow the cell format.
After playing around with this a bit, the only solution I can see is to do a
Paste Special/Text instead of a full Paste onto the worksheet.
Unfortunately, you'll lose most of the layout, so this might make the job of
parsing out the data you need more difficult.

--
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" wrote in message
...
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


.