Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 287
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 806
Default How do I add an integer to an existing integer?

=123456*10+7

Regards,
Bernd
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Random Integer Don[_4_] New Users to Excel 3 September 20th 09 11:08 PM
integer integer format Excel Worksheet Functions 1 May 3rd 07 06:45 PM
help with rounding up to whole integer kjcramp Excel Discussion (Misc queries) 3 April 10th 06 07:00 PM
how do I test for Integer? Stephen P Thomas Excel Worksheet Functions 4 July 13th 05 10:30 AM
positive integer? JZip Excel Discussion (Misc queries) 2 January 7th 05 07:37 PM


All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"