I would be inclined to round it to the 10 cent mark and then just subtract a
penny. So something like this perhaps

=ROUNDUP(A1, 1)-0.01
or
=ROUND(A1, 1)-0.01
--
HTH...

Jim Thomlinson


"Louise" wrote:

I am trying to create a Price Book with SRP's. I need to have all prices end
with a 9. How do I replace the last digit?