Formatting cells with imaginary or complex quantities

1

1940LaSalle

How does one format a cell that contains an imaginary or complex
quantity (such as one containing the function IMPRODUCT) to show a
specified number of decimal places in either the real part of the
result and/or the multiplier of the imaginary quantity i? From what
I've seen, cells with complex or imaginary quantities get the general
format, and I don't see that there's an option to vary this. Thanks.
 
H

Harlan Grove

[email protected] wrote...
How does one format a cell that contains an imaginary or complex
quantity (such as one containing the function IMPRODUCT) to show a
specified number of decimal places in either the real part of the
result and/or the multiplier of the imaginary quantity i? From what
I've seen, cells with complex or imaginary quantities get the general
format, and I don't see that there's an option to vary this. Thanks.
Click to expand...

=TEXT(ROUND(IMREAL(z),3),"0.000;-0.000;")
&TEXT(ROUND(IMAGINARY(z),3),"+0.000\i;-0.000\i;")
 
Top