Why not make the (c) part of the custom format: 0.00 (c)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Iguss" wrote in message
...
Would you please advise of =If formula where I can round 5.020(c) so It
displays something like that at the end 5.02(c) or any other letter that
can
show up in the field.

Thank you