Filling table with data, numbers don't come across correctly?

[Lil2606]

Hi all, sorry I may not managed to correctly phrase my initial question...

I have a Source Table with several columns (and hundreds of rows) from which "Code" and "Identifier" are causing troubles. In "Code" there is always a 2 digit number. (00, 01, 02 etc.) in "Identifier" there is always a 5 digit number (00000, 00001, 00002 etc.) and in my new table I'm supposed to have a "Product ID" put together from the "Code-Identifier" (00-00001, 01-00002 etc.)

I tried:

[COLOR=#333333][IMG]http://icons.iconarchive.com/icons/double-j-design/ravenna-3d/24/File-Copy-icon.png[/IMG]
<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Join(Array(SourceTable.ListRows(i).Range(1, SourceTable.ListColumns("Code").Index).Value, SourceTable.ListRows(i).Range(1, SourceTable.ListColumns("Identifier").Index).Value), "-")</code>[/COLOR]

but I get all sorts of numbers except for the ones in the SourceTable, eventough the format seems right. The SourceTable has a custom number formatting applied to display the zeros and such.. is that the problem?

Please help!

Posted on ExcelForum as well link: https://www.excelforum.com/excel-pr...s-dont-come-across-correctly.html#post5126733

 

[Lil2606]

There is an example sheet on ExcelForum

 

[Lil2606]

Solution on Excel Forum