View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tim m
 
Posts: n/a
Default expanding numbers in cells

Try formatting the cells to number rather than general and then widening the
column for your long number to fit.

"BobPoz" wrote:

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