How do I add an integer to an existing integer?

How do I add an integer to an existing integer?

Post by QWFyb2 » Sat, 19 Dec 2009 04:08:01


If I have the # 123456, How do I add the # 7 to the end of it. So the end
result will be 1234567.
 
 
 

How do I add an integer to an existing integer?

Post by TWlrZSB » Sat, 19 Dec 2009 04:29:02

Aaron

=A1&7

Mike

 
 
 

How do I add an integer to an existing integer?

Post by David Bidd » Sat, 19 Dec 2009 04:31:33

=A1&"7" if you want text
=--(A1&"7") if you want a number
 
 
 

How do I add an integer to an existing integer?

Post by Bernd » Sat, 19 Dec 2009 06:46:32

=123456*10+7

Regards,
Bernd