adding zero before number?

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

Last edited: