|
想把小写数字转换成中文的一二三.....并且是带小数点的
例如12.5转成一二点五
现在得到了你的提示,我已做成了相关的宏,如下
Sub te()
Dim aa, ss, bb, cc, ar, ad, hh, sd
aa = Application.Find(".", A1, 1)
ss = [NUMBERSTRING(Left(A1, Find(".", A1, 1) - 1), 3)]
cc = IsError(Application.Find(".", Range("A1"), 1))
bb = [NUMBERSTRING(Right(A1, Len(A1) - Find(".", A1, 1)), 3)]
ar = [NUMBERSTRING(Right(A1, Len(A1) - Find(".", A1, 1)), 3)]
ad = "点"
sd = [NUMBERSTRING(A1,3)]
'Range("A5") = [If(cc, sd, ss & ad & bb)]
If cc = False Then
Range("A5") = ss & ad & bb
End If
If cc = True Then
Range("A5") = sd
End If
End Sub
我在2010版可以运行,我现在是想把它变成函数,但变不了,你可以帮我?
|
|