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.