Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering 16 digit numbers - last digit turns to zero
While creating a sheet with credit card numbers I noticed that upon placing
the 16th digit and any after that , the numbers are zeros There are no fomats in those cells. Can anyone help? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering 16 digit numbers - last digit turns to zero
dreamer wrote:
While creating a sheet with credit card numbers I noticed that upon placing the 16th digit and any after that , the numbers are zeros There are no fomats in those cells. Can anyone help? Assuming you aren't going to be doing math on these values format the cell as text. gls858 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering 16 digit numbers - last digit turns to zero
Or create a custom format to show it as 1234 1234 1234 1234. That way, it is
also esier to read the card numbers Custom format as 0000 0000 0000 0000 -- HTH Kassie Replace xxx with hotmail "gls858" wrote: dreamer wrote: While creating a sheet with credit card numbers I noticed that upon placing the 16th digit and any after that , the numbers are zeros There are no fomats in those cells. Can anyone help? Assuming you aren't going to be doing math on these values format the cell as text. gls858 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering 16 digit numbers - last digit turns to zero
But for the custom number format to work, the value will have to be entered as a
number (not text). And that means that the 16th digit would be changed to a 0 again. Kassie wrote: Or create a custom format to show it as 1234 1234 1234 1234. That way, it is also esier to read the card numbers Custom format as 0000 0000 0000 0000 -- HTH Kassie Replace xxx with hotmail "gls858" wrote: dreamer wrote: While creating a sheet with credit card numbers I noticed that upon placing the 16th digit and any after that , the numbers are zeros There are no fomats in those cells. Can anyone help? Assuming you aren't going to be doing math on these values format the cell as text. gls858 -- Dave Peterson |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering 16 digit numbers - last digit turns to zero
http://www.contextures.com/xlfaqapp.html#SigDigits
Regards Ken......................... "dreamer" wrote in message ... While creating a sheet with credit card numbers I noticed that upon placing the 16th digit and any after that , the numbers are zeros There are no fomats in those cells. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering 6 digit numbers into a cell with zeros at the beginning | Excel Worksheet Functions | |||
Entering 16 digit numbers in cell | New Users to Excel | |||
Entering a 16 digit number | Excel Discussion (Misc queries) | |||
entering a 16 digit number - last value changes to 0 | Excel Discussion (Misc queries) | |||
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions |