| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine a range with a constant number
I have looked for something on this and have yet to find the answer...
I have a range in Workbook1 sheet1 column A that I need to copy to... 1 2 3 4 etc.. Workbook2 sheet1 column A, But I need to add the number 908 before the copied data...so when it is pasted into Workbook 2 its value is; 9081 9082 9083 9084 etc... How do I go about doing this?? Thanks, Hans |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can we make one constant number to be act as variable | Excel Discussion (Misc queries) | |||
| how i can show only the constant number after the comma | Excel Discussion (Misc queries) | |||
| When I type a constant number I want another number to appear. | Excel Worksheet Functions | |||
| range * constant | Excel Programming | |||
| Multiply a Range by a Constant | Excel Programming | |||
Threaded Mode
