You can declare Constants equal to the number and then use the
constants in your code...
Const OnePtOneE_3 As Double = 0.0011
Const OnePtOneE_11 As Double = 0.000000000011
x = OnePtOneE_11 * 2
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"elfnor"wrote in message
When I enter the line
x = 1.1e-3
in the visual basic editor and hit return, it is automatically
reformated to
x = 0.0011
Can I stop this? It makes it hard to check that constants such as
1.1e-11 are programed correctly.