| 
 | 
								
									
										|  |  
										|  |  
										| |  Click here to copy the following block |  | 
 Function FormatCreditCard(ByVal text As String) As String
 Dim i As Long
 
 
 If Len(text) = 0 Then Exit Function
 
 
 For i = Len(text) To 1 Step -1
 If InStr("0123456789", Mid$(text, i, 1)) = 0 Then
 text = Left$(text, i - 1) & Mid$(text, i + 1)
 End If
 Next
 
 FormatCreditCard = Format$(text, "!@@@@ @@@@ @@@@ @@@@")
 
 End Function
 | 
 |  
										|  |  
										|  |  
 
	
		| Submitted By :
					Nayan Patel 
					 (Member Since : 5/26/2004 12:23:06 PM) |  
		|  |  
		| 
				 | Job Description :   
			He is the moderator of this site and  currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting. |  
		| View all (893) submissions by this author 
			(Birth Date : 7/14/1981 ) |  |  |