Can anyone help me with this?<br><br>Simply the question is the subject. I'm wanting to add 1 onto the number 0001 resulting in th value becoming 0002. Obviousely when adding a plain 1 it gets rid of the preceding zeros and becomes 2.<br>I need to preceding "000" so the biggest number that it can go to it 9999.<br><br>Thanks for any help<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Adding 1 to 0001
- Thread starter 99mel
- Start date
You will have to convert your result to a string... look at this sample.<br><br> Dim i As Integer<br> Dim s As String<br> <br> i = 2<br> s = Format(CStr(i), "000#"
<br> MsgBox s<br><br>Hope this helps.<br>Paul<br>
<br> MsgBox s<br><br>Hope this helps.<br>Paul<br> 
MichaelRed
Programmer
? Format(0001 + 1, "00000"<br>00002<br><br>or any number of variations on the theme of "FORMAT"
<br>00002<br><br>or any number of variations on the theme of "FORMAT" - Status
Similar threads
