Display absolute value of complex number

[Guest]

How do I change the format of an Excel cell containing a complex number to
just display the absolute value of the complex number, or failing that,
reduce the number of digits displayed ?

 

[Dana DeLouis]

How do I change the format of an Excel cell containing a complex number to

just display the absolute value of the complex number,

I don't believe Excel's formatting can do this alone. I think you would
need an additional function.
If A1 has the text 3+4i
then
=IMABS(A1)
retuns 5