That is actually a pretty good way of resolving it. Thanks!. One more question. One of the values I need displayed would be to the 10th power. However "0.00\E+10" somehow just returns the text "E+1" and some integer.

I was trying to display 3.32e10 using your format modified to the 10th: =TEXT(A1/1e10, "0.00\E+10") and it would return as 3.31E15. I'm assuming contextually 0 and # represent a function within excel. I'm just not sure how to make it actually display 0 rather than calling a function.