劉任昌EXCEL_ACCESS外部資料VBA自訂函數
VBA程式碼
'劉任昌使用VBA將T轉成10**12, B=^
Public Function TBM_number(abc) '函數將 123.45T 文字轉成數字
i = Len(abc) 'Len() 回傳字串長度
c = Right(abc, 1) 'Right(abc, i) 取 abc 右邊第 1 位
If c = "T" Then
n = Val(Left(abc, i - 1)) * 1000000000000# '將 T 轉為兆
ElseIf c = "B" Then
n = Val(Left(abc, i - 1)) * 1000000000 '將 B 轉為十億
ElseIf c = "M" Then
n = Val(Left(abc, i - 1)) * 1000000 '將 M 轉為百萬
Else
n = Val(Left(abc, i - 1)) '直接轉為數字
End If
TBM_number = n
End Function
https://shaoxuanwu.blogspot.com/2023/05/excelaccess.html
回覆刪除https://ericc0606takmung.blogspot.com/2023/05/blog-post.html
回覆刪除https://takmingd11117223.blogspot.com/2023/05/excelaccessvba.html
回覆刪除作者已經移除這則留言。
回覆刪除https://1dth36.blogspot.com/2023/05/excelaccessvba.html
回覆刪除https://takmingd11117330.blogspot.com/2023/05/excelaccessvba.html
回覆刪除https://hsupppppp.blogspot.com/2023/05/excelaccessvba.html
回覆刪除https://d11117328.blogspot.com/2023/05/excelaccessvba.html
回覆刪除https://d11117331.blogspot.com/2023/05/excelaccessvba.html
回覆刪除https://tina930823.blogspot.com/2023/05/excelaccess.html
回覆刪除https://michael-hou.blogspot.com/2023/05/excelaccessvba.html
回覆刪除https://linggg11111.blogspot.com/2023/05/excelaccessvba.html
回覆刪除https://takmingg.blogspot.com/2023/05/excelaccessvba.html
回覆刪除https://guixiu1485.blogspot.com/2023/05/vbat1012-b-public-function-tbmnumberabc.html
回覆刪除https://www0709.blogspot.com/2023/05/excelaccessvba.html
回覆刪除作者已經移除這則留言。
回覆刪除https://purplefish-ouo.blogspot.com/2023/05/excelaccessvba.html
回覆刪除https://pandora-mo.blogspot.com/2023/05/excelaccessvba.html
回覆刪除https://jingas0109.blogspot.com/2023/05/excelaccessvba.html
回覆刪除https://d11117331.blogspot.com/2023/05/blog-post.html
回覆刪除https://shaoxuanwu.blogspot.com/2023/05/access.html
回覆刪除https://steven0918.blogspot.com/2023/05/access.html
回覆刪除https://htm-css-javascript-java.blogspot.com/2023/05/blog-post.html
回覆刪除https://0968033863.blogspot.com/2023/05/excelaccessvba.html
回覆刪除作者已經移除這則留言。
回覆刪除https://kuan8573.blogspot.com/2023/05/vbat1012-b-public-function-tbmnumberabc.html
回覆刪除https://yiiii22.blogspot.com/2023/06/excelaccessvba.html
回覆刪除https://yiiii25.blogspot.com/2023/06/accesstableformexternal-data.html
回覆刪除