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

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.

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.

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.

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

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