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