ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pasting problem (https://www.excelbanter.com/excel-discussion-misc-queries/191767-pasting-problem.html)

Dan S

Pasting problem
 
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

Gord Dibben

Pasting problem
 
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 DataT to C wizard and clear anything in the delimited by section.

Try again.


Gord Dibben MS Excel MVP


On Wed, 18 Jun 2008 11:50:00 -0700, Dan S
wrote:

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



Dan S

Pasting problem
 
That did the trick - thanks!

Dan

"Gord Dibben" wrote:

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 DataT to C wizard and clear anything in the delimited by section.

Try again.


Gord Dibben MS Excel MVP


On Wed, 18 Jun 2008 11:50:00 -0700, Dan S
wrote:

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





All times are GMT +1. The time now is 05:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com