View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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