How to change complex 0.122345687+0.87659454j to 3 decimal places

[erwan]

How to change complex 0.122345687+0.87659454j to 3 decimal places

 

[Ron Rosenfeld]

How to change complex 0.122345687+0.87659454j to 3 decimal places

=COMPLEX(ROUND(IMREAL(A1),3),ROUND(IMAGINARY(A1),3),"j")

or, if you might have either an "i" of "j" suffix:

=COMPLEX(ROUND(IMREAL(A1),3),ROUND(IMAGINARY(A1),3),RIGHT(A1,1))

--ron

 

[erwan]

thank you ron but still have slight problem when doing iteration.

 

[Ron Rosenfeld]

thank you ron but still have slight problem when doing iteration.

Please be more specific. I don't understand what you mean in this context.
--ron