Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format in Excel
When I try to enter a credit card number in an cell it always chages to zero
when I push enter |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format in Excel
Do you enter it as 1234 5678 9012 3456, or as 1234567890123456
"Kevin" wrote: When I try to enter a credit card number in an cell it always chages to zero when I push enter |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format in Excel
Hi Kevin
Excel can only work with 15 digits, so your 16th value will always change to 0 if you enter as numeric. You need to enter it as Text (which Kassie's suggestion of including the spaces would produce). Alternatively, pre-format the column as Text then make your entries (without the spaces if you wish) or type a single quote ' before entering the number. This will make it a text entry, but the quote will not show as part of the number. -- Regards Roger Govier "Kevin" wrote in message ... When I try to enter a credit card number in an cell it always chages to zero when I push enter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, conditional format (font red) referencing another cell? | Excel Worksheet Functions | |||
How do I format a cell in excel to display 0.5 hrs as 00:30 | Excel Discussion (Misc queries) | |||
Excel - cell format switches to custom when switching language | Excel Discussion (Misc queries) | |||
How do i get excel to format a cell for a negative result. | Excel Discussion (Misc queries) | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions |