Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In VBA editor x = 1.1e-3 is reformated to x = 0.0011
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
In VBA editor x = 1.1e-3 is reformated to x = 0.0011
maybe this
x = "1.1e-3" "elfnor" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
In VBA editor x = 1.1e-3 is reformated to x = 0.0011
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
In VBA editor x = 1.1e-3 is reformated to x = 0.0011
Maybe something like:
X = 1.1 * 10 ^ -3 or X = 1.1 * 10 ^(-3) to make sure the -3 is not read as a subtract operation. -- Regards, Bill Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA editor | Excel Discussion (Misc queries) | |||
VB Editor | Excel Discussion (Misc queries) | |||
VB Editor | Excel Programming | |||
VB editor bug? | Excel Programming | |||
VBA Editor | Excel Programming |