Set specific exponent value in Scientific Notation

[corrosion]

I have a field that tracks numeric values in scientific notation. I need to be able to set all the values to the same exponent when I print out a report, or review the values in a form. As an example, I have the following three values:


4.40E-12, 4.80E-13, 1.01E-11. I want to report them as 4.40E-12, .480E-12, and 10.10E-12. Is there a way to do this?

[orange]

Tried Google but can't find a method to get consistent E format.
Seems it wants to have 1 digit, then decimal point, then 2 other digits, then an E value.

Here is my sample.

x=23.4E-10:y=4.5162345E-11
?format(x,"scientific")
2.34E-09
?format(y,"scientific")
4.52E-11

Haven't found example to have a consistent E-xx.

1. Debug.Print Format(9123.4876, "Scientific")
2. yields
3. 9.12E+03

Examples seem to be restricted to 3 digits???
See this for more info.

[Micron]

Are the table field values numeric or text data type? Perhaps more importantly, could the control for these values in the report be calculated and use text? If so, a function or perhaps just an expression should be able to handle it.
E.g. 4.80E-13*10^12 & "E-" & "12" would give you 0.48E-12 but would have to be a string. Trailing zeros 0 before the E would complicate things.