| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when certain number is typed in a cell to display a message | Excel Discussion (Misc queries) | |||
| How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
| Conditional Number formatting? | Excel Discussion (Misc queries) | |||
| Phone Number Formatting | Excel Discussion (Misc queries) | |||
| Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
Threaded Mode
