Prepending numbers

  • Thread starter Thread starter Florian68
  • Start date Start date
F

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.
 
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.
 
Back
Top