All the change I made does is to eliminate the 'i' so the imaginary number can be used as a number. Nothing except the 'i' is 'lost' - and you could add that back to the result if that's what you want, either via a custom number format or by adding &"i" to the formula.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|