Excel VBA: 1.0 becomes 1#

Question

For some reason when I type

Dim version
version = 1.0

in the vb editior in excel, the editor automatically changes it to

Dim version
version = 1#

Any idea why?

Just a suggestion but maybe you should use a `String` variable for version? — ttaaoossuuuu, Apr 29 '14 at 08:06
http://stackoverflow.com/questions/10890892/use-of-symbol-hash-in-vba-macro/10891051#10891051 — Siddharth Rout, Apr 29 '14 at 10:42

score 4 · Accepted Answer · answered Apr 29 '14 at 07:59

4

version = 1# tells the compiler to assign a double.

The Documentation defines other suffixes:

answered Apr 29 '14 at 07:59

z̫͋

1 Answers1