I'm downloading data from a database that gives me
quantity in this format.
S 100M
B 100M
S 350M
S 5M

S=sell B=buy

I need to change this data just to give me the dollar
value.

so i need the 1st example to just read -100,000,000 and
the 2nd example to be 100,000,000, and so forth.

are there any functions or vba code to assist me in this
dilema.

thank you