See the TRANSFORM() function with "@^" format code and the Format property with "^".

Vlad

>I am looking for a way to handle scientific notation. I have tables with measurements in scientific notation such as 3.00E-14. These are incredably small.
>
> I can average them by using the VAL() function. But after I get an answer I can find now way to get it back into scientific notation.
>
>If someone has heard of a way I would greatly appreciate an answer.