Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cells with 0 as the tenth digit | Excel Worksheet Functions | |||
how to format cell to display S("6 digit number here) | New Users to Excel | |||
conditional format on first & last digit on 3 digit cell data | New Users to Excel | |||
Solver returns non binary answer in binary constrained cells | Excel Worksheet Functions | |||
Display Binary Leading Zeros | Excel Discussion (Misc queries) |