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
---