View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default Round-down complex numbers

You probably have some formula like = A1 & B1 & "i" to display this.
Change this to:

=TEXT(A1,"0.0") & TEXT(B1,"0.0") & "i"

to display the numbers to one decimal place.

Hope this helps.

Pete