View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lewis Lewis is offline
external usenet poster
 
Posts: 14
Default Formatting complex number display

Hello there in never never land.
Can someone help me in formatting complex numbers.
How do I get the following simple "complex" function to display as "-1+0i",
rather than
-1+1.22514845490862E-016i ?
function : =+COMPLEX(COS(PI()),SIN(PI()))
--
Lewis
Engineering Solutions