| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
=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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? |
|
#6
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the size of the print in a drop down list? | Excel Discussion (Misc queries) | |||
| select drop down list 1 value will change the value in dr... | Excel Worksheet Functions | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
| How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Hybrid Mode
