What do I do when the data type LONG is TOO SHORT? I am doing LotusScript calculations and need to be able to add several large numbers (BILLIONS of dollars)… I get overflow error. I have 4 numbers (all data type long) and when added they amount to 2,630,672,832.00. The script pukes trying to add the numbers. Is there another way to do this?
Thanks so much for reading!
Trish
Subject: When data type LONG is TOO SHORT
Use a Double instead – it can work with much larger numbers. If the mantissa for a Double is too small to express the precision you need, then you’ll need to work with text instead.
Subject: RE: When data type LONG is TOO SHORT
Thank you, Stan! As usual, your suggestion hit the mark. I just changed the dim from long to double and it worked perfectly!
Trish