| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add an integer to an existing integer?
If I have the # 123456, How do I add the # 7 to the end of it. So the end
result will be 1234567. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add an integer to an existing integer?
Aaron
=A1&7 Mike "Aaron" wrote: If I have the # 123456, How do I add the # 7 to the end of it. So the end result will be 1234567. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add an integer to an existing integer?
=A1&"7" if you want text
=--(A1&"7") if you want a number -- David Biddulph "Aaron" wrote in message ... If I have the # 123456, How do I add the # 7 to the end of it. So the end result will be 1234567. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add an integer to an existing integer?
=123456*10+7
Regards, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random Integer | New Users to Excel | |||
| integer | Excel Worksheet Functions | |||
| help with rounding up to whole integer | Excel Discussion (Misc queries) | |||
| how do I test for Integer? | Excel Worksheet Functions | |||
| positive integer? | Excel Discussion (Misc queries) | |||
Hybrid Mode
