Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What data type?
Hi,
I'm having problems finding data type that will sustain big numbers (10 or more digits). My prog (simple LCG/MLCG random number generator) works best with Long data type, but even then it's quite limited in terms of size of the numbers it can crunch. Apparently, Variant data type should allow bigger numbers (Excel help says: "Numeric data can be any integer or real number value ranging from -1.797693134862315E308 to -4.94066E-324 for negative values and from 4.94066E-324 to 1.797693134862315E308 for positive values"), but when I declare my variables as Variant, the prog reports "overflow" even for the parameters that Long variable can crunch. Thanks srdjan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert data type | Excel Discussion (Misc queries) | |||
Wrong data type | Excel Discussion (Misc queries) | |||
specify data type in MS Query? | Excel Discussion (Misc queries) | |||
Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
Data Type | Excel Programming |