You must have entered it incorrectly. I tested it with 255254456 and it
returns 255254451. Note the formula

=INT(A1/10)*10+1

--

HTH

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


"kingie" wrote in message
...
Sorry spoke to soon this formula works if the original number ends in 0
but
all other numbers increase by one. eg 554433226 becomes 554433227. More
help
please
Kingie

"kingie" wrote:

Just to say big thanks to Bob Philips you got me out of a jam.
kingie

"kingie" wrote:

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?