![]() |
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. |
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