Ooops!

I guess you want to keep the (...) if it's there?

Try this if that's the case:

=ROUND(LEFT(A1,FIND("(",A1&"(")-1),2)&MID(A1,FIND("(",A1&"("),255)

Note that this will return TEXT even if the entry doesn't have a (...):

5.020(c) returns the text value 5.02(c)
1.025 returns the TEXT value 1.03

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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