用我的程序换你的可用分~~
Function TurnNumber(StrTemp As String) As String
'编制:蒋玉龙
'QQ:66840199
'功能:将数据转换成为财会专用数据,每三位一个分隔符号
'转换以字符方式转换
Dim MyPos As String '全部的字符
Dim IntPart As String '整数部分
Dim IntPartTemp As String '临时的整数部分
Dim StrOther As String '剩余部分
MyPos = InStr(1, StrTemp, ".")
If MyPos = 0 Then
IntPart = StrTemp
StrOther = ""
Else
IntPart = Left(StrTemp, MyPos - 1)
StrOther = Right(StrTemp, Len(StrTemp) - MyPos + 1)
End If
Do While Not Len(IntPart) <= 3
IntPartTemp = "," & Right(IntPart, 3) & IntPartTemp
IntPart = Left(IntPart, Len(IntPart) - 3)
Loop
IntPartTemp = IntPart & IntPartTemp
TurnNumber = IntPartTemp & StrOther
End Function
以上为VB中的写法,脚本需要将定义去掉~~
Function TurnNumber(StrTemp)'编制:蒋玉龙
'QQ:66840199
'功能:将数据转换成为财会专用数据,每三位一个分隔符号
'转换以字符方式转换
Dim MyPos '全部的字符
Dim IntPart '整数部分
Dim IntPartTemp '临时的整数部分
Dim StrOther '剩余部分
MyPos = InStr(1, StrTemp, ".")
If MyPos = 0 Then
IntPart = StrTemp
StrOther = ""
Else
IntPart = Left(StrTemp, MyPos - 1)
StrOther = Right(StrTemp, Len(StrTemp) - MyPos + 1)
End If
Do While Not Len(IntPart) <= 3
IntPartTemp = "," & Right(IntPart, 3) & IntPartTemp
IntPart = Left(IntPart, Len(IntPart) - 3)
Loop
IntPartTemp = IntPart & IntPartTemp
TurnNumber = IntPartTemp & StrOther
End Function
如果你觉得好,请转给偶点可用分
如果你觉得不好,请离开这里——记得关门哦~~