Im trying to make a function to append a number with 0's, which I know cant work as an interger seeing as 00000 will recognize as 0, so trying to put it as a string.
I have two problems with my code:-
Dim endRule As String
endRule = Int("0")
While Len(Str(startRule)) < 7
startRule = Str(startRule & "0")
1 - On first run startRule becomes " 0" (space at the front of the string).
2 - the "0" is never appended to the string, it always is " 0" (which the unknown space from issue #1).
My code runs great if it starts with a number apart from 0.
Does anyone have any suggestions?