displaying complex number in Excel

Y

YK

When one cell contains COMPLEX(1,1), it displays "1+i" nicely.
However, when it is like COMPLEX(1/3,1), it displays "0.3333333333333333+i".
I noticed they are also flushed left, unlike normal numbers.
Is there any format to tell Excel to display complex number with limited
number of digits? Formatting the cell does not seem to do anything on
complex numbers.
 
B

Bernard Liengme

COMPLEX displays a text value
You may want to experiment with formulas such as
=COMPLEX(ROUND(1/3,2),1)
best wishes
 
Y

YK

Thanks,

However rounding inside "COMPLEX" would not maintain the intended value.
I guess we just have to live with it....

It would have been nice if the number formatting could be applied to complex
numbers.

Thanks again.

YK
 

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

Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Excel does not accept text format! 0
Display absolute value of complex number 1
Cumulative formula for word table 0
Number format 1
Excel not responding before calculations 1
complex number in excel 2003 sp3 3

Top