Hi
I want to convert the number to 8 digits for example if the ID equals 19 the result should be 00000019 by adding six zeros before the value.can I solve this proplem using for each ?
Discussion posts and replies are publicly visible
Did you check the text() function? A formatting pattern like "00000000" should get you what you want.