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.

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.

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.