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

S

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

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

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

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