Display 2 decimal places

[Simply_Me]

I am trying to subtract "3.50" from cell A2. if the result is positive value then a (+) sign will be appended to the result (like +0.50).

I tried this formula

Please Login or Register  to view this content.

but the result does not show the decimal place.

[Fluff13]

How about

Please Login or Register  to view this content.

[TMS]

Try:

Please Login or Register  to view this content.

[rorya]

You could just give the cell a custom number format of:
+0.00;-0.00

so that it is still an actual number.

[Simply_Me]

Thank you to both of you sir Fluff13 and TMS. Works great.

[Fluff13]

You're welcome & thanks for the feedback

[TMS]

You're welcome.


Rory's solution is better, IMO.