I am trying to format a a string as follows:
The idea here is to offset the string and then scale it.
assume we have -5.
I want to add +5 to this (offsetting) and then multiply the result by 2 (scaling).
Thus the result for -5 after "formatting" must be 0.
Similarly if value is -4...we must get -4(+5) = 1...1*2 = 2 after "formatting"
I am not able to figure out how to do this in VB6 using format function.
Any help is greatly appreciated