If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pasting (replacing) problem
Hi! How can I prevent changing all my "01/1" to "1.jan" (or to "38353") when copying tables from Word to Excel or when running Find/Replace tool. The only way I can get those "01/1" is to select text format of a cell and type it manually. But I have thousands of "01/1" (01/2, 01/3 ... 02/1, 02/2 ...) cells. Any idea? -- berti ------------------------------------------------------------------------ berti's Profile: http://www.excelforum.com/member.php...o&userid=29597 View this thread: http://www.excelforum.com/showthread...hreadid=492987 |
#2
|
|||
|
|||
Pasting (replacing) problem
Format the receiving cells as text before you paste. Use Paste special,
click Text -- Kind regards, Niek Otten "berti" wrote in message ... Hi! How can I prevent changing all my "01/1" to "1.jan" (or to "38353") when copying tables from Word to Excel or when running Find/Replace tool. The only way I can get those "01/1" is to select text format of a cell and type it manually. But I have thousands of "01/1" (01/2, 01/3 ... 02/1, 02/2 ...) cells. Any idea? -- berti ------------------------------------------------------------------------ berti's Profile: http://www.excelforum.com/member.php...o&userid=29597 View this thread: http://www.excelforum.com/showthread...hreadid=492987 |
#3
|
|||
|
|||
Pasting (replacing) problem
Ok, that aswers my question, but .. what if I would like to keep the same format as it was in Word? I mean, with this solution I get unformatted text in one column and then have to use Text import wizard to get columns with a tab delimiter (and again forse the columns with 01/1 to text format) and then put borders around them. Thanks, Berti -- berti ------------------------------------------------------------------------ berti's Profile: http://www.excelforum.com/member.php...o&userid=29597 View this thread: http://www.excelforum.com/showthread...hreadid=492987 |
#4
|
|||
|
|||
Pasting (replacing) problem
Paste special as Microsoft Office Word document object
-- Kind regards, Niek Otten "berti" wrote in message ... Ok, that aswers my question, but .. what if I would like to keep the same format as it was in Word? I mean, with this solution I get unformatted text in one column and then have to use Text import wizard to get columns with a tab delimiter (and again forse the columns with 01/1 to text format) and then put borders around them. Thanks, Berti -- berti ------------------------------------------------------------------------ berti's Profile: http://www.excelforum.com/member.php...o&userid=29597 View this thread: http://www.excelforum.com/showthread...hreadid=492987 |
#5
|
|||
|
|||
Pasting (replacing) problem
Yes, that is true, but it doean't help me, cause then I don't have cells, just one object! My problem is that a have lots of tables made in Word but now i would like to do sth. with their data in Excel. It seems that a best solution would be to replace / with e.g. \. In my case 01/1 means round/location so changing it to \ won't damage anything. I have the same problem with ":". 2:0 should represent a result (score) in my table, but gets converted to 2:00, time! Maybe I can disable this automatic formatting somwhere? Regards, Berti Paste special as Microsoft Office Word document object -- berti ------------------------------------------------------------------------ berti's Profile: http://www.excelforum.com/member.php...o&userid=29597 View this thread: http://www.excelforum.com/showthread...hreadid=492987 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
.. any help appreciated .. i think it's a pasting HTML problem. | Agent C | General Discussion | 2 | January 26th, 2006 09:49 PM |
Test Format Problem When Pasting | Will F. | Publisher | 3 | January 20th, 2005 04:43 PM |
Reinstalling OE... | KAR | Outlook Express | 24 | August 21st, 2004 06:52 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
word error | mac | General Discussions | 1 | May 6th, 2004 08:14 AM |