If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Prepending numbers
How do I prepend or add a number to the beginning of a series of numbers?
For instance, I have a 4 digit number, 1001, that I want to be 11001. This is the beginning number in a chart of accounts that is 500 numbers long. Using Format Cells to make it appear as a 5 digit number doesn't work, because I need to upload the data into an accounting software program. I have figured out a work-a-round by adding 10000 to 1001, copy, paste value, repeat as necessary, but it seems like a lot of extra work to achieve something that could be simplier. |
#2
|
|||
|
|||
Prepending numbers
hi
is this the only number you have to do this to. if so, it sounds like you have completed the task. but the "repeat as necessary" phrase you use makes me think you have more. try this enter 10000 in to a cell off to the side. copy it. then high light the numer(s) you wish to change editpaste specialAdd if you do have a lot more numbers to do, this may speed up the process because you can do all in one paste. Regards FSt1 "Florian68" wrote: How do I prepend or add a number to the beginning of a series of numbers? For instance, I have a 4 digit number, 1001, that I want to be 11001. This is the beginning number in a chart of accounts that is 500 numbers long. Using Format Cells to make it appear as a 5 digit number doesn't work, because I need to upload the data into an accounting software program. I have figured out a work-a-round by adding 10000 to 1001, copy, paste value, repeat as necessary, but it seems like a lot of extra work to achieve something that could be simplier. |
#3
|
|||
|
|||
Prepending numbers
adding 10000 to 1001, copy, paste value, repeat as necessary
Not sure what you mean by repeat as necessary but it can be done in-place all at once. Is this what you're doing: Enter 10000 in an empty cell Copy that cell Then select the numbers you want to change Then EditPaste SpecialAddOK Doesn't get a whole lot easier than that. -- Biff Microsoft Excel MVP "Florian68" wrote in message ... How do I prepend or add a number to the beginning of a series of numbers? For instance, I have a 4 digit number, 1001, that I want to be 11001. This is the beginning number in a chart of accounts that is 500 numbers long. Using Format Cells to make it appear as a 5 digit number doesn't work, because I need to upload the data into an accounting software program. I have figured out a work-a-round by adding 10000 to 1001, copy, paste value, repeat as necessary, but it seems like a lot of extra work to achieve something that could be simplier. |
Thread Tools | |
Display Modes | |
|
|