vb中如何把分数转换为小数

来源:百度知道 编辑:UC知道 时间:2024/06/08 08:57:44
若在TEXT.TEXT中输入1/1000,,在计算时需要把1/1000转换为小数0.001,应该怎么样写代码?

Private Sub Form_Click()
Dim I as single,J as single,S as double,A
A=Split(trim(Text1.Text),"/")
If Ubound(A)=1 Then
i=val(A(0))
j=val(A(1))
If j=0 Then
Msgbox "分母不能为0"
Else
S=i/j
Msgbox "分数的值为:" & s
End IF
Else
Msgbox "不是一个有效的分数"
End If
End Sub

dim s as string,i as long
s = text.text
i = instr(s,"/")
print format(val(left(s,i-1)) / val(mid(s,i+1)),"0.000")