Convert E to exponent?

N

Niek Otten

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
Converting URLs in comments to Markdown-formatted links 2
Solving two equations with known exponent 5
Difficulty with compatibility mode and Track Changes 2
How do I add an exponent to a math equation? 4
Reference Cell Altering Formulas 1
Change Excel Exponent Default Setting 0
Convert PDF to Visio File or Editable PDF in Visio 0

Top