Excel, Hash (#) in VBA Calculations
Hi Folks,
I have recently inherited care of an Excel XP model that contains the
following calculations, containing the # symbol.
Amount = Amount / 100#
NewValue = OldValue * -1#
I can see where the variables Amount, NewValue and Old Value are declared
but nothing on the #.
The end results sor t of make sense if the # symbols were in fact the %
sign. Other than that I am totally confused.
Does this use of the # symbol make sense to anyone.
TIA
John Howard
Sydney, Australia
|