Convert E to exponent?

[Ed from AZ]

what format will give me
1x10^13
instead of
1E13

Ed

 

[Niek Otten]

No format, but this formula:
=LEFT(TEXT(A1,"0.00E+00"),4)&"x10^"&RIGHT(TEXT(A1,"0.00E+00"),2)

 

[Ed from AZ]

Okay - an extra column, but I can get there! Thanks.

Ed