NUMBER PROBLEM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try this...........

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

Vaya con Dios,
Chuck, CABGx3
 
Back
Top