Assuming all entries follow this format:

number(text) = 5.020(c)
number = 5.020

=ROUND(LEFT(A1,FIND("(",A1&"(")-1),2)+0

--
Biff
Microsoft Excel MVP


"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