Private Sub Command1_Click() i = Format("11,111,111.00", "") Print i End Sub
up orPrivate Sub Command1_Click() i = "11,111,111.00" stra = Replace(i, ",", "") stra = Replace(stra, "0", "") stra = Replace(stra, ".", "") Print stra End Sub笨方法啊!
好象vb中有一个字符替换函数的. dim strTmp as string dim i as longstrTmp="11,111,111.00"replace(strtmp,",",chr(0)) strTmp=mid(strtmp,0,instr(strtmp,".")-1)i=val(strtmp)
为什么不可以 dim iTemp dim strTemp strTemp = "11,111,111.00" iTem = Clng(stTemp) strTemp = CStr(iTemp) 不久完成了么
Dim s As String, arrstr() As String, j As Integer, s1 As String s = "11,111,111.00" arrstr = Split(s, ",") For j = 0 To UBound(arrstr) s1 = s1 + arrstr(j) Next s1 = Left$(s1, 8)
Dim x As String Dim str As String str = "1,111,111.00" x = CStr(CDbl(str)) Debug.Print x
i = Format("11,111,111.00", "")
Print i
End Sub
i = "11,111,111.00"
stra = Replace(i, ",", "")
stra = Replace(stra, "0", "")
stra = Replace(stra, ".", "")
Print stra
End Sub笨方法啊!
dim strTmp as string
dim i as longstrTmp="11,111,111.00"replace(strtmp,",",chr(0))
strTmp=mid(strtmp,0,instr(strtmp,".")-1)i=val(strtmp)
dim iTemp
dim strTemp
strTemp = "11,111,111.00"
iTem = Clng(stTemp)
strTemp = CStr(iTemp)
不久完成了么
s = "11,111,111.00"
arrstr = Split(s, ",")
For j = 0 To UBound(arrstr)
s1 = s1 + arrstr(j)
Next
s1 = Left$(s1, 8)
Dim x As String
Dim str As String
str = "1,111,111.00"
x = CStr(CDbl(str))
Debug.Print x