这不难,再加点代码即可:
Public Function inchX(X As Single) As String
'功能:厘米换算英寸,并分数化表示
Dim A As Long, B As Long, C As Long, dec As Single
Dim Ar
Dim i As Long, j As Long
Dim val As Single
If X = 0 Then
inchX = 0
Else
Ar = Array(0, 1, 2, 3, 5, 7, 11, 13, 17, 19)
X = X / 2.54
A = Int(X)
dec = X - A
val = 1
For j = 2 To 20
For i = 0 To UBound(Ar, 1)
If Ar(i) > j Then Exit For
If Abs(dec - Ar(i) / j) < val Then
val = Abs(dec - Ar(i) / j)
C = j
B = Ar(i)
End If
Next
Next
If A < 12 Then
If B <> 0 Then
inchX = A & " " & B & "/" & C & "''"
Else
inchX = A
End If
Else
inchX = Int(A / 12) & "'" & (A Mod 12) & " " & B & "/" & C & "''"
End If
End If
End Function
点击下载此附件