Thread: excel help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
kassie kassie is offline
external usenet poster
 
Posts: 80
Default excel help

That is Excel for you. Do you want this card number as a number, or as text?
If you type it as 1234 1243 1234 1243, you will see all the digits, provided
your column width is properly set. You do not want to do calculations on the
card number, so inserting it as text in this manner, overcomes the limitation
on numbers

--
Hth

Kassie Kasselman


" wrote:

This is driving me nuts...what am I doing wrong??!! I created a
spreadsheet to keep track of personal budgeting info. When I type a
16-digit credit card account number into a cell and then hit "Enter",
the last digit of my number automatically changes to a zero (0). Any
advice?? Thnx!