software

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

=58744amp;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

quot;yalanolaquot; gt; wrote in message
...
gt;
gt; for example:
gt;
gt; existing number is 1115, 1116,1117,.... I want add the same number 58744
gt; to
gt; the left of each number, what function should I use?
gt; Thanks
gt; =58744amp;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: = --(58744amp;A1)
Copy B1 down

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Hi

Yet another variation to the 2 answers you have received from Anne and
Max, would be to use a Custom Format.
Formatgt;Cellsgt;Numbergt;Custom 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 Govierquot;Maxquot; gt; wrote in message
...
gt;gt; =58744amp;A1
gt;
gt; Assuming the source numbers are listed in A1 down: 1115, 1116 ...
gt; and we want the result of the concat to be a real number (instead of
gt; text)
gt; try this slight revision to Anne's suggestion above
gt; in say, B1: = --(58744amp;A1)
gt; Copy B1 down
gt;
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt;
gt;