adding a number to text problem
hi. i have a string that looks like "AB00000001" that i want to add a +1 to. 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 to solve this for a very long time...