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?