How can you format cells in a column to display a 50 digit binary

[shazglen]

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.

 

[Gary''s Student]

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.

 

[BobT]

If you are importing from a text file, import it as Text (not "General" or
something else). Once it's in Excel, you can then apply any reformatting you
need.

 

[Dave Peterson]

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.