Prepending numbers

[Florian68]

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.

 

[T. Valko]

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 Edit>Paste Special>Add>OK

Doesn't get a whole lot easier than that.