Display absolute value of complex number
 

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 ?

Display absolute value of complex number
 

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

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"GraemeD" wrote in message
...
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 ?