TomJeffries
Technical User
Does anyone know of a way to format compex numbers in EXCEL. For example as -0.02+0.0087i rather than the scientific notation form returned by a calculation -0.02+8.700000003E-002.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formatting Compex Numbers
- Thread starter TomJeffries
- Start date
- Status
If your complex number is in cell A1, then you can get the format you want with this formula in some other cell:
[blue]
[/color]
Hide column "A" if you only want to see the formatted version.
[blue]
Code:
=TEXT(IMREAL(A1),"general")&"+"&TEXT(IMAGINARY(A1),"general")&"i"Hide column "A" if you only want to see the formatted version.
- Status
Similar threads
- Locked
- Question