Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stopping Excel from reformatting data as a date? | Excel Discussion (Misc queries) | |||
stopping value(from cell) from increasing when vlookup copied down | Excel Discussion (Misc queries) | |||
Stopping a constant variable cell from being copied. | New Users to Excel | |||
Converting Excel data into semicolon delimited text file | Excel Discussion (Misc queries) | |||
converting copied data to numbers in excel xp | New Users to Excel |