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

Advertisements

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

Advertisements

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top