Why not just test the size of the imaginary part and if it is really, really
small force the display of 0?:

=IMREAL(A1)&IF(ABS(IMAGINARY(A1))<0.0000000001,"+0 i",IMAGINARY(A1))

will display:
-1+0i
if A1 contains:
=+COMPLEX(COS(PI()),SIN(PI()))

--
Gary's Student
gsnu200702


"Lewis" wrote:

Hello there in never never land.
Can someone help me in formatting complex numbers.
How do I get the following simple "complex" function to display as "-1+0i",
rather than
-1+1.22514845490862E-016i ?
function : =+COMPLEX(COS(PI()),SIN(PI()))
--
Lewis
Engineering Solutions