ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   NUMBER PROBLEM (https://www.excelbanter.com/new-users-excel/32726-number-problem.html)

Rebecca

NUMBER PROBLEM
 
Greetings. I am using EXCEL 2003. I have a column in WORD that contains
rows of numbers of varying lengths (see below). I want to copy this column
and insert it into a column in EXCEL, but when I do this decimals are
automatically added, and some rows result in calculations. How do I do this
copying and inserting so the number stay exactly as they are in the WORD
column (no calculations, no decimal points, etc). Please explain in easy
English because I am new to EXCEL. Thanks.

23444555
243444
44444445454545545777788
45456565
52
1132434
etc.

CLR

Try this...........

First, format the cells you wish to paste to as TEXT
Then, Copy PasteSpecial Text OK

Vaya con Dios,
Chuck, CABGx3


"Rebecca" wrote in message
...
Greetings. I am using EXCEL 2003. I have a column in WORD that contains
rows of numbers of varying lengths (see below). I want to copy this

column
and insert it into a column in EXCEL, but when I do this decimals are
automatically added, and some rows result in calculations. How do I do

this
copying and inserting so the number stay exactly as they are in the WORD
column (no calculations, no decimal points, etc). Please explain in easy
English because I am new to EXCEL. Thanks.

23444555
243444
44444445454545545777788
45456565
52
1132434
etc.





All times are GMT +1. The time now is 07:09 AM.

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