I rekon that it will convert the complex number to the text value.
I need this number other calculations as a complex value.

I don't understand. Excel doesn't have a Complex object type.
Excel uses strings to represent Complex data.

You wanted to use:
=COMPLEX(1/3,4/3)
0.333333333333333+1.33333333333333i

and reduce it to 4 significant digits each
+ 0.3333 + 1.3333j

It's in the proper string format to do other calculations:

=IMPOWER(A2,2)
correctly returns:
-1.6666+0.88877778j

(vs -5/3 + (8/9)j had we not reduced the accuracy)
Would you like a macro function instead?
--
HTH :)
Dana DeLouis


"Raj" wrote in message
...
I rekon that it will convert the complex number to the text value. Where as
I
further need this number other calculations as a complex value. Other
alternative I can think of is to reconvert to a complex number but it
makes
the formula so big and hard to modify in future.

Also I need to repeat these calculations.

can't we have a better solution.

"Dana DeLouis" wrote:

however so many ddecimal igits are not desired. Can we restrict the
decimal
digits from the formula say 4 to 5.

Would this idea work for you?

=TEXT(IMREAL(A1)," + 0.####; - 0.####") & TEXT(IMAGINARY(A1)," +
0.####; -
0.####") & "j"

--
HTH :)
Dana DeLouis


"Raj" wrote in message
...
When I try to multiply the complex number by a fixed number the result
comes
out to be

4.69452551984877E-002+0.121677051039698j
The formula looks like

=IMPRODUCT(Data!D13,(Data!D5/Data!D8)^2)

where Data!d3 is a complex number and Data!D5 and Data!D8 are numbers .

however so many ddecimal igits are not desired. Can we restrict the
decimal
digits from the formula say 4 to 5.