I would also put an Isnumeric test in there, just in case.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SunTEam" wrote in message
...
SunTEam napisa³(a):
Bob Phillips napisa³(a):

If myCell.NumberFormat = "#,##0.00"


ok .now its' working
i changed "#,##0.00" to "0.00"