Hi,

I'm recreating a "transID" made up of year,month, date,branch,
transaction number in the mainframe. The excel data contains all these
fields, but I've had to use formatcellscustom00000 to ensure the
transaction number has leading zeros.

I'm trying to concatenate these fields, but the transaction number
reverts back no leading zeros, so what should be 2006010511100123,
looks like 200615111123.

I need to exactly replicate the "transID"

Any ideas ?

Rich