Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Number Problem
D'all,
In a column, I hav 16 digits numbers. But when I add 4 digit number after last digit of that number becomes 4 zeros at last. e.g. 9503170011002910 (16 digit number) 1425 (4 digit number) becomes 95031700110029100000 whether it should be 95031700110029101425 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Number Problem
Excel can only handle 15 digit numbers, after that everything gets shown as
0. If you want 20 digits you will have to hold it as text. -- __________________________________ HTH Bob "Sandeep Jangra" wrote in message ... D'all, In a column, I hav 16 digits numbers. But when I add 4 digit number after last digit of that number becomes 4 zeros at last. e.g. 9503170011002910 (16 digit number) 1425 (4 digit number) becomes 95031700110029100000 whether it should be 95031700110029101425 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Number Problem
On Nov 4, 10:06*pm, Sandeep Jangra
wrote: In a column, I hav 16 digits numbers. *But when I add 4 digit number after last digit of that number becomes 4 zeros at last. *e.g. 9503170011002910 (16 digit number) 1425 (4 digit number) becomes 95031700110029100000 whether it should be 95031700110029101425 If you want to use the number in calculations, you are out of luck. Excel recognizes only the first 15 digits when a number is entered. If the "number" is really an identifier (e.g. serial number or tax id) and it will not be used in computation, you can enter it as text by prefixing with an apostrophe (single quote). For example, '95031700110029101425. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number Format Problem | Excel Discussion (Misc queries) | |||
Help with a problem have tried a number of things | Excel Worksheet Functions | |||
number to text problem | Excel Discussion (Misc queries) | |||
NUMBER PROBLEM | New Users to Excel | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |