software

Hi!
How can I prevent changing all my quot;01/1quot; to quot;1.janquot; (or to quot;38353quot;)
when copying tables from Word to Excel or when running Find/Replace
tool.

The only way I can get those quot;01/1quot; is to select text format of a cell
and type it manually.

But I have thousands of quot;01/1quot; (01/2, 01/3 ... 02/1, 02/2 ...)
cells.

Any idea?--
berti
------------------------------------------------------------------------
berti's Profile: www.excelforum.com/member.php...oamp;userid=29597
View this thread: www.excelforum.com/showthread...hreadid=492987Format the receiving cells as text before you paste. Use Paste special,
click Text

--
Kind regards,

Niek Otten

quot;bertiquot; gt; wrote in
message ...
gt;
gt; Hi!
gt; How can I prevent changing all my quot;01/1quot; to quot;1.janquot; (or to quot;38353quot;)
gt; when copying tables from Word to Excel or when running Find/Replace
gt; tool.
gt;
gt; The only way I can get those quot;01/1quot; is to select text format of a cell
gt; and type it manually.
gt;
gt; But I have thousands of quot;01/1quot; (01/2, 01/3 ... 02/1, 02/2 ...)
gt; cells.
gt;
gt; Any idea?
gt;
gt;
gt; --
gt; berti
gt; ------------------------------------------------------------------------
gt; berti's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29597
gt; View this thread: www.excelforum.com/showthread...hreadid=492987
gt;

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: www.excelforum.com/member.php...oamp;userid=29597
View this thread: www.excelforum.com/showthread...hreadid=492987Paste special as Microsoft Office Word document object

--
Kind regards,

Niek Otten

quot;bertiquot; gt; wrote in
message ...
gt;
gt; Ok, that aswers my question, but ..
gt; what if I would like to keep the same format as it was in Word?
gt; I mean, with this solution I get unformatted text in one column and
gt; then have to use Text import wizard to get columns
gt; with a tab delimiter (and again forse the columns with 01/1 to text
gt; format)
gt; and then put borders around them.
gt;
gt; Thanks,
gt; Berti
gt;
gt;
gt; --
gt; berti
gt; ------------------------------------------------------------------------
gt; berti's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29597
gt; View this thread: www.excelforum.com/showthread...hreadid=492987
gt;

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 quot;:quot;.
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

gt; Paste special as Microsoft Office Word document object--
berti
------------------------------------------------------------------------
berti's Profile: www.excelforum.com/member.php...oamp;userid=29597
View this thread: www.excelforum.com/showthread...hreadid=492987