View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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.