Generally problems involving values come from the determinations.
Your determination of a String is most likely the cause
Usually strings (Strung Numbers) are used to define arguments within a sequeunce - for example pulling data from recordsets or sequencing alogrithms.
Try using Integer or Constant value
Alternatives
Dim "your value" as Integer
Dim "your value" as Long Integer
Dim "your value" as Char
Dim "your value" as Boolean
Dim "your value" as Const
If you want to define your output to a whole number then determine the value as an Integer - to include the point value, especially needed when refering to minus numbers, Long Integer.
If you are planning to perform complex calculations then try looking up the theory of Boolean for algebraic method.
If you are using the ouput for a TEXT format you should use Char (Character)
By simply changing the determination of your value you should be able to find the desired result
- Snippet from wikipedia - Definition String -
A string is generally understood as a
data type storing a sequence of data values, usually bytes, in which elements usually stand for characters according to a
character encoding, which differentiates it from the more general
array data type. In this context, the terms
binary string and
byte string are used to suggest
strings in which the stored data does not (necessarily) represent text.
- Snippet from wikipedia - Definition Integer -
The
integers (from the
Latin integer, which means with untouched integrity, whole, entire) are the set of numbers consisting of the
natural numbers including 0 (
0,
1,
2,
3, ...) and their
negatives (0,
−1, −2, −3, ...). They are numbers that can be written without a fractional or decimal component, and fall within the set {... −2, −1, 0, 1, 2, ...}. For example, 65, 7, and −756 are integers; 1.6 and 1½ are not integers. In other terms, integers are the numbers one can count with items such as apples or fingers, and their negatives, including 0.
- Snippet from wikipedia - Definition Character (Char) -
In
computer and machine-based
telecommunications terminology, a
character is a unit of
information that roughly corresponds to a
grapheme, grapheme-like unit, or symbol, such as in an
alphabet or
syllabary in the
written form of a
natural language.
An example of a character is a letter,
numeral, or
punctuation mark. The concept also includes
control characters, which do not correspond to symbols in a particular natural language, but rather to other bits of information used to process text in one or more languages. Examples of control characters include
carriage return or
tab, as well as instructions to
printers or other devices that display or otherwise process text