Home |
Search |
Today's Posts |
#1
|
|||
|
|||
entering 16 digit number in Excel suffix 0 comes automatically
When I key in beyong 15 digits number in a cell of Excel 2000 or office XP
Excel eats up 16th digit and places a 0 and go-on like that. Please help me |
#2
|
|||
|
|||
Excel numeric precision is 15 significant digits.
If you don't need to calculate with the number, for example credit card numbers, make it text by preceding the entry with an apostrophe. The apostrophe will not show. Another way is to format the cells as text before entering the numbers. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Ravi Mohan Sahay" <Ravi Mohan wrote in message ... When I key in beyong 15 digits number in a cell of Excel 2000 or office XP Excel eats up 16th digit and places a 0 and go-on like that. Please help me |
#3
|
|||
|
|||
Ravi,
http://www.smokeylake.com/excel/vfaq.htm. Look at NUMBERS -- ONLY 15 DIGITS . -- Earl Kiosterud www.smokeylake.com/excel ------------------------------------------- "Ravi Mohan Sahay" <Ravi Mohan wrote in message ... When I key in beyong 15 digits number in a cell of Excel 2000 or office XP Excel eats up 16th digit and places a 0 and go-on like that. Please help me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
How do I auto number cells in an Excel template? | Excel Discussion (Misc queries) | |||
Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
Excel should let me circle a cell or number in the spreadsheet fo. | Excel Discussion (Misc queries) | |||
How do I set up a field in an Excel form to number it incremental. | Excel Worksheet Functions |