how to add numbers to the left or right of the existing numbers?
 

for example:

existing number is 1115, 1116,1117,.... I want add the same number 58744 to
the left of each number, what function should I use?
Thanks

how to add numbers to the left or right of the existing numbers?
 

=58744&A1
That will put 58744 followed by the value in cell A1.

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"yalanola" wrote in message
...

for example:

existing number is 1115, 1116,1117,.... I want add the same number 58744
to
the left of each number, what function should I use?
Thanks

how to add numbers to the left or right of the existing numbers?
 

=58744&A1

Assuming the source numbers are listed in A1 down: 1115, 1116 ...
and we want the result of the concat to be a real number (instead of text)
try this slight revision to Anne's suggestion above
in say, B1: = --(58744&A1)
Copy B1 down

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

how to add numbers to the left or right of the existing numbers?
 

Hi

Yet another variation to the 2 answers you have received from Anne and
Max, would be to use a Custom Format.
FormatCellsNumberCustom 58744#

Now when you enter 1115 in the cell, it will show as 587441115 and it
will increment on the last 4 numbers as you drag the cell down using
fill series.

--
Regards

Roger Govier


"Max" wrote in message
...
=58744&A1

Assuming the source numbers are listed in A1 down: 1115, 1116 ...
and we want the result of the concat to be a real number (instead of
text)
try this slight revision to Anne's suggestion above
in say, B1: = --(58744&A1)
Copy B1 down

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---