format of complex numbers

D

dhb

Hello,

I have a problem concerning the data format when entering a comple
number in Excel.

I want to enter the complex number 2+0.01i

So I enter “=COMPLEX(2;0,01;"i")” but when the number shows up in th
worksheet it looks like: 2+1E-002i and I would like it to appear a
2+0.01i .

So how do I change the format of the complex number? I have tried t
use the Format cell option but it does not work
 
D

Dave Peterson

=complex() returned a string--not a number. That's why changing the number
format won't work.

I don't have a pretty suggestion, but couldn't you just build that string
yourself:

="2"&"+"&"0.01"&"i"

or maybe you could control it exactly the way you want:

=TEXT(A1,"0")&TEXT(B1,"0.00")&"i"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Inconsistent formatting of section numbers 0
How can the font and size of (all) citation numbers be altered? 1
Paragraph numbering in Word 1
Finding the proper style field and the numbered paragraph value within the style 0
How to change font & size of (all) citation numbers? 7
How to invert Cols/Rows? 2
displaying complex number in Excel 2

Top