importing complex numbers to excel from matlab

[wabodie]

After exporting complex number matrix from matlab, each cell depicts only the real part of the number. The imaginary part disappears. I have tried using excel link and the same thing happens. Excel seems to ignore the complex portion of the number. Ive activated the toolpack add-in but this does not solve the problem. Any suggestions, please?

 

[PaddyD]

hi - welcome to the board!

try:

=COMPLEX(ROUND(IMREAL(A1),2),ROUND(IMAGINARY(A1),2))

...change rounding as required.

vba option: http://support.microsoft.com/?kbid=213294