=INT(A1/10)*10+1

--

HTH

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


"kingie" wrote in message
...
I have a list of random numbers generated by excel. I now want the same
list
of nine digit numbers to all end in 1. EG 255254456 to become 255254451
is
there a way i can do this in excel?