HickeHiskelig
Member
hi. i want to add zeros before a number so that the length of the text is 8 digits. how do i do this? the information i get looks like "AB00000001" , i want to make it "AB00000002"
by using Trim("AB" & ToNumber(Right[number];8))+1) i get AB2, but i miss all the zeros in between. how do i solve this? i have been trying for hours
thanks
by using Trim("AB" & ToNumber(Right[number];8))+1) i get AB2, but i miss all the zeros in between. how do i solve this? i have been trying for hours
thanks
Last edited: