When using the complex function, the default format has many decimal places,
both for real and imaginary parts. I would like to change this and I don't
know how to do it.

I am assuming that your real and imaginary numbers are coming from other
calculations?

You could always try rounding inside the function itself:

=COMPLEX(ROUND(RealNo,2),ROUND(ImagNo,2),'j")

for example.
--
John C


"michel74" wrote:

When using the complex function, the default format has many decimal places,
both for real and imaginary parts. I would like to change this and I don't
know how to do it.

Check out this web site
http://support.microsoft.com/default.aspx/kb/213294
Hope this helps

JB

"michel74" wrote in message
...
When using the complex function, the default format has many decimal
places,
both for real and imaginary parts. I would like to change this and I don't
know how to do it.