Thread
:
Round-down complex numbers
View Single Post
#
2
Posted to microsoft.public.excel.misc
Pete
Posts: n/a
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
Reply With Quote