Display Scientific Notation 2.5E-07 to 2.5 x 10^-7

[zargothrax]

Hey all,

I want to display scientific E notation to exponential notation. IE, in a cell I want 2.5E-07 to look like 2.5 x 10^-7.

Is this possible to do in VBA?

Thanks in advance.

[BMV]

No, 10^-7 only as text in the other cell or in the same but value will be lost.

[zargothrax]

Ah, I did not think so. Thanks for the quick reply.