Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
multiply by actual number in cell | Excel Worksheet Functions |