Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
Prepending text to a cell entry | Excel Worksheet Functions |