About Us

Peter Thompson

I need to view & work with a spreadsheet that contains complex numbers.
Right now the cells with complex numbers show up as #NAME?.

Leo Heuser

"Peter Thompson" <Peter skrev i en
meddelelse ...
I need to view & work with a spreadsheet that contains complex numbers.
Right now the cells with complex numbers show up as #NAME?.

Hi Peter

Use COMPLEX(), which is an ordinary Excel function, to
convert real and imaginary coefficients into a complex number.
All functions for complex numbers reside in Analysis ToolPak
(not my spelling :-) and start with IM (e.g IMABS()), so you have
to install and activate Analysis ToolPak (Tools Add-ins) in
order to use those functions.

--
Best regards
Leo Heuser

Followup to newsgroup only please.

ChuckF

Coudl you give us an example of a few of these complex numbers?

Peter Thompson wrote:
I need to view & work with a spreadsheet that contains complex numbers.
Right now the cells with complex numbers show up as #NAME?.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
FedEx tracking numbers in Excel	Adam J	Excel Discussion (Misc queries)	0	July 24th 06 07:34 PM
Converting numbers stored as dates to text in Excel	David from Furdale	Excel Discussion (Misc queries)	1	July 17th 06 06:34 PM
Convert numbers stored as text to numbers Excel 2000	Darlene	Excel Discussion (Misc queries)	6	January 31st 06 08:04 PM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?	C-Man23	Excel Worksheet Functions	3	January 19th 06 09:52 AM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?	C-Man23	Excel Worksheet Functions	1	January 9th 06 01:23 PM

Menu

About Us