Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I perform a calculation on a 20 digit number in an excel ?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I perform a calculation on a 20 digit number in an excel ?
"vaishali" wrote in message ... Hi V. You might use the Decimal datatype in VBA. It has 28 digit precision. Suppose you enter your 20 digit numbers in A1 and A2 with ' in front. The sum is =myplus(A1,A2) where myplus is your own user defined function Function myplus$(x$, y$) myplus = CDec(0) + x + y End Function Paste that little function after you have pressed Alt+F11, and chosen Insert Module The function will then sit in Module1 of the workbook, and can be used from the function list. Same thing, nearly, with minus, multiply, divide but multiplications, for instance, will necessarily be rounded. Hans T. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I perform time calculation formuals in excel | Excel Worksheet Functions | |||
How to perform matrix calculation in excel? | Excel Discussion (Misc queries) | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |