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

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?

=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?

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?

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?

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?

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

"Bob Phillips" wrote:

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?