View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
YK YK is offline
external usenet poster
 
Posts: 8
Default displaying complex number in Excel

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.