Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rebecca
 
Posts: n/a
Default 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   Report Post  
CLR
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? Steve Excel Worksheet Functions 0 January 30th 05 09:11 PM
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 05:33 PM
Defining a number in a cell by text then subtracting it by the tex Crowraine Excel Worksheet Functions 1 December 16th 04 07:49 AM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 07:12 PM
multiply by actual number in cell CJ Cerezo Excel Worksheet Functions 3 November 29th 04 09:43 PM


All times are GMT +1. The time now is 05:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"