LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
BobPoz
 
Posts: n/a
Default expanding numbers in cells

I am tranferring data from a 31/2" disc to an excel program. All fiields in
columns appear correctly except the most important one. These are scanning
numbers that are up to 35 numbers. In this column it gives me 6 or 8 numbers
and then a +21 sign after. How do I expand these numbers to their actual
length?
Bob
 
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
need to compare two lists and identify cells with same numbers in Bockhamptoner Excel Discussion (Misc queries) 8 September 11th 08 11:34 AM
Excel auto formats cells with numbers - Can it be disabled? Jeromey Setting up and Configuration of Excel 1 May 21st 06 01:17 AM
How do I merge 2 cells to 1 when contents are numbers traceyclarity Excel Discussion (Misc queries) 3 January 27th 06 03:54 PM
Pivot Table keep apart cells text that I've formatted as numbers Paulo Bevervanso Excel Worksheet Functions 2 September 21st 05 08:45 PM
Converting negative numbers in a range of cells to zero Dede Excel Discussion (Misc queries) 3 January 14th 05 06:23 PM


All times are GMT +1. The time now is 06:10 AM.

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

About Us

"It's about Microsoft Excel"