View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How can you format cells in a column to display a 50 digit binary

You will want to keep the numberformat of that field as text. Excel only keeps
track of 15 significant digits when working with real numbers.

shazglen wrote:

I am trying to import into excell a column of data that each cell contains a
50 digit binary code. My problem is that excell doesnt want to display the
leading zeros. Each binary code may have a different number of leading zero's.


--

Dave Peterson