| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel changes the last number I type in column???
After setting up a worksheet for a budget, I type in the credit card numbers.
If the last number of the card is 3 for example, when I press enter to go on to the next line, it changes it to 0. Anyone here know what I'm doing wrong? Thanks so much for any help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel changes the last number I type in column???
Excel supports only 15 numeric digits.
Either: -- format your cells as text before you enter the number, or -- precede your credit card number with an apostrophe (') Regards, Fred. "Mike" wrote in message ... After setting up a worksheet for a budget, I type in the credit card numbers. If the last number of the card is 3 for example, when I press enter to go on to the next line, it changes it to 0. Anyone here know what I'm doing wrong? Thanks so much for any help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel changes the last number I type in column???
Excel will only allow numbers to 15 significant digits. After the 15th digit
it changes all the remaining digits to 0. You have to enter the string of numbers as TEXT. Either pre-format the cell as TEXT or precede the entry with an apostrophe like this: '1234567890123456. The apostrophe will not be displayed in the cell. -- Biff Microsoft Excel MVP "Mike" wrote in message ... After setting up a worksheet for a budget, I type in the credit card numbers. If the last number of the card is 3 for example, when I press enter to go on to the next line, it changes it to 0. Anyone here know what I'm doing wrong? Thanks so much for any help |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel changes the last number I type in column???
Thanks Fred!!!
"Fred Smith" wrote: Excel supports only 15 numeric digits. Either: -- format your cells as text before you enter the number, or -- precede your credit card number with an apostrophe (') Regards, Fred. "Mike" wrote in message ... After setting up a worksheet for a budget, I type in the credit card numbers. If the last number of the card is 3 for example, when I press enter to go on to the next line, it changes it to 0. Anyone here know what I'm doing wrong? Thanks so much for any help |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel changes the last number I type in column???
Thanks T !!!!
"T. Valko" wrote: Excel will only allow numbers to 15 significant digits. After the 15th digit it changes all the remaining digits to 0. You have to enter the string of numbers as TEXT. Either pre-format the cell as TEXT or precede the entry with an apostrophe like this: '1234567890123456. The apostrophe will not be displayed in the cell. -- Biff Microsoft Excel MVP "Mike" wrote in message ... After setting up a worksheet for a budget, I type in the credit card numbers. If the last number of the card is 3 for example, when I press enter to go on to the next line, it changes it to 0. Anyone here know what I'm doing wrong? Thanks so much for any help |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel changes the last number I type in column???
You're welcome!
-- Biff Microsoft Excel MVP "Mike" wrote in message ... Thanks T !!!! "T. Valko" wrote: Excel will only allow numbers to 15 significant digits. After the 15th digit it changes all the remaining digits to 0. You have to enter the string of numbers as TEXT. Either pre-format the cell as TEXT or precede the entry with an apostrophe like this: '1234567890123456. The apostrophe will not be displayed in the cell. -- Biff Microsoft Excel MVP "Mike" wrote in message ... After setting up a worksheet for a budget, I type in the credit card numbers. If the last number of the card is 3 for example, when I press enter to go on to the next line, it changes it to 0. Anyone here know what I'm doing wrong? Thanks so much for any help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - mixed type (line, column, stacked column) in one char | Charts and Charting in Excel | |||
| When I type a mobile number in Excel it wont include the first 0 | Excel Discussion (Misc queries) | |||
| In Excel, how can I type a number with a circle around it? | Excel Worksheet Functions | |||
| Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
| Can Excel add a set percentage to a cell automatically when you type in a number | Excel Worksheet Functions | |||
Linear Mode
