Try the Format() formula. Something like:

Let vMyVar = Format(vMyVar, "00000000000000000.0")

HTH,
tchid2


"OrientalPearl" wrote:

Howday everyone,

Just a quick question here. How can I disable scientific notation to
kick in when manipulating a variable in VBA, i.e. to display/use/...
its value as 123456789123456789 as exactly it should be rather than
1.23E+18. Basically scientific notation needs to be totally switched
off here. The variable is of type Single by the way.

Many thanks
Frank