MrExcel Publishing
Your One Stop for Excel Tips & Solutions

no of digits


Posted by ihsan huzmeli on January 10, 2002 9:00 AM

Excel 97 does not understand more than 15 digit numbers, we want to enter 20 digit numbers. what is the solution to this?


Posted by Juan Pablo G. on January 10, 2002 9:13 AM

If Excel is assuming mm/dd, even though I have the cell custom formatted as mm/yy, then why do I have no problem with 11/99, or 11/00. Excel can't be assuming 99 and 00 are days?

Posted by Mark W. on January 10, 2002 10:35 AM

You want to perform arithmetic on 20 digit numbers? (nt)

Posted by Joe Was on January 10, 2002 10:46 AM

If the data is just an "ID" or some non-math input then use a Text input. Or, format more than one cell to hold your input Like: Column1=1234, column2="-", column3=123456789, column4="-", column5=123456789. Or, put the Integer value in one cell and the remainder in another? Or, use sheet formulas to work with large numbers, like: ROUND or enter the number as scientific notation? JSW