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.

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.

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

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.

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