I have a variable (A) defined and would like to change it's value to Scientific notation.

I can't seem to get this to work.

A = ActiveCell.Value

Now I want to convert this to scientific notation and store it back into variable A

Help!