How do I format complex numbers ?

[ks]

When I do math operations with complex numbers, the results are shown in long
formats with many digits after the decimal point. Something like :

0.0358698745876568+0.099839597397397i

How can I change it to fewer digits? Please help!

ks

 

[FSt1]

hi
can you format it with fewer decimal places ie
on the menu bar...
format>cells>number tab>catagory = number...then set the decimal places

regards
FSt1

 

[Ron Rosenfeld]

When I do math operations with complex numbers, the results are shown in long
formats with many digits after the decimal point. Something like :

0.0358698745876568+0.099839597397397i

How can I change it to fewer digits? Please help!

ks

Complex numbers, in Excel, are entered as strings.

You have to round the real and imaginary parts separately, and then recombine
them.

e.g.

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

(although if your suffix is always an "i" or a "j", you can change the
RIGHT(A1,1) to "i" or "j").
--ron

 

[ks]

Ron,

Thank you very much. It worked!

Regards,
ks

 

[Ron Rosenfeld]

Ron,

Thank you very much. It worked!

Regards,
ks

You're welcome. Glad to help. Thanks for the feedback.
--ron