Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel help
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel help
Excel's number precision is limited to 15 digits, so the last digit is
simply rounded to accommodate that. You could try formatting the cell as text, or keeping it general format and placing spaces or hyphens between the groups of 4 digits. 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |