View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default How can you format cells in a column to display a 50 digit binary

Use the Import Wizard (especially if its a .csv file):

Data Import External Data Import data...

Tell the Wizard the field is Text. This way YOU control the formatting, not
Excel.
--
Gary''s Student - gsnu200858


"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.