Pasting problem

D

Dan S

When I paste into Excel (from anther app) it's not putting everything in one
cell. For example 100.56 would be 100 is cell A1 & 56 in cell A2. Is there a
clipboard setting or something I need to change?

Dan
 
G

Gord Dibben

I would say that the copying part makes Excel think the copied data is text and
the text to columns wizard is set to dot-delimited.

Open the Data>T to C wizard and clear anything in the delimited by section.

Try again.


Gord Dibben MS Excel MVP
 
D

Dan S

That did the trick - thanks!

Dan

Gord Dibben said:
I would say that the copying part makes Excel think the copied data is text and
the text to columns wizard is set to dot-delimited.

Open the Data>T to C wizard and clear anything in the delimited by section.

Try again.


Gord Dibben MS Excel MVP
Click to expand...
 
Top