| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Zero appears at the end of a string of 16 digits. Two zeros after
After I enter 16 digits into a cell, a zero appears at the end of the 16
digit number. Two zeros appear at the end of 17. What is causing this? |
|
#2
|
|||
|
|||
|
Zero appears at the end of a string of 16 digits. Two zeros after
Excel supports 15 significant digits. If you want to see more, you can
preformat the cell as text (then type in your 16 digit entry). Or you can prefix your entry with an apostrophe: '1234123412341234 (Both of these will leave the value in the cell as text.) cawhitaker wrote: After I enter 16 digits into a cell, a zero appears at the end of the 16 digit number. Two zeros appear at the end of 17. What is causing this? -- Dave Peterson |
|
#3
|
|||
|
|||
|
Zero appears at the end of a string of 16 digits. Two zeros a
Is there any way to change the 15 to say 20?
"Dave Peterson" wrote: Excel supports 15 significant digits. If you want to see more, you can preformat the cell as text (then type in your 16 digit entry). Or you can prefix your entry with an apostrophe: '1234123412341234 (Both of these will leave the value in the cell as text.) cawhitaker wrote: After I enter 16 digits into a cell, a zero appears at the end of the 16 digit number. Two zeros appear at the end of 17. What is causing this? -- Dave Peterson |
|
#4
|
|||
|
|||
|
Zero appears at the end of a string of 16 digits. Two zeros a
Not than I'm aware of.
cawhitaker wrote: Is there any way to change the 15 to say 20? "Dave Peterson" wrote: Excel supports 15 significant digits. If you want to see more, you can preformat the cell as text (then type in your 16 digit entry). Or you can prefix your entry with an apostrophe: '1234123412341234 (Both of these will leave the value in the cell as text.) cawhitaker wrote: After I enter 16 digits into a cell, a zero appears at the end of the 16 digit number. Two zeros appear at the end of 17. What is causing this? -- Dave Peterson -- Dave Peterson |
|
#5
|
|||
|
|||
|
Zero appears at the end of a string of 16 digits. Two zeros a
Thanks, Dave. This answered my question. It is greatly appreciated.
"Dave Peterson" wrote: Not than I'm aware of. cawhitaker wrote: Is there any way to change the 15 to say 20? "Dave Peterson" wrote: Excel supports 15 significant digits. If you want to see more, you can preformat the cell as text (then type in your 16 digit entry). Or you can prefix your entry with an apostrophe: '1234123412341234 (Both of these will leave the value in the cell as text.) cawhitaker wrote: After I enter 16 digits into a cell, a zero appears at the end of the 16 digit number. Two zeros appear at the end of 17. What is causing this? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of time a character appears in a string | Excel Worksheet Functions | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
| Need insert a dash in between last 4 digits in text string | Excel Worksheet Functions | |||
| How do I specific digits in a long string? | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
