I wish to change the last digit in a list of random numbers. To a.

[kingie]

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?

 

[Bob Phillips]

=INT(A1/10)*10+1

--

HTH

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

 

[kingie]

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

 

[kingie]

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

 

[Bob Phillips]

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]

Yes your dead right i don't know what i did wrong but it now works . Thanks
Best regards
kingie