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