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:
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
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:
Code:
[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