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.