Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Increment Number
#2
Not Solved
Hi,
We can increment all ur test SSN as given below.
Code:
SSN="123-12-1239"  ' old SSN
SSN = Cstr(CLng(Replace(SSN,"-",""))+1)
SSN = Left(SSN,3) & "-" & Mid(SSN,4,2) & "-" & Right(SSN,4)
msgbox SSN  ' prints new SSN
Reply


Messages In This Thread
Increment Number - by caippers - 06-10-2011, 02:10 AM
RE: Increment Number - by vIns - 06-10-2011, 06:12 PM
RE: Increment Number - by rajpes - 07-05-2011, 08:42 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Count the number of 3 number appers between 0-3333 SaranKumarV 1 3,542 09-20-2010, 06:32 PM
Last Post: rdemers25

Forum Jump:


Users browsing this thread: 1 Guest(s)