Share via

imsub formula result

Anonymous
2013-05-03T16:35:56+00:00

The imsub formula result will not display with 2 decimal places, have tried to change this using the number section but it doesn't work

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2013-05-03T16:58:41+00:00

    Complex numbers are just text strings in Excel. Any number format you apply to a cell with a complex number will be ignored.

    If you want the result of subtracting complex numbers to be displayed in a specific way, you'd have to write a custom function in VBA for that purpose.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments