excel表格如何实现十进制与十二进制的转换（excel二进制转换为十进制的方法）

可以考虑用自定义函数

按ALT+F11进入VBA编辑界面,插入模块

写自定义函数代码

若十二进制数用0,1,2,3,4,5,6,7,8,9,A,B表示,

则函数格式格式

Function xl换十二进制(ByVal x As Long) As String

Dim s(11)

Dim ss As String, i, k As Integer

For i = 0 To 9

s(i) = i

Next i

s(10) = "A"

s(11) = "B"

ss = ""

Do While x > 0

k = x Mod 12

ss = s(k) & ss

x = Int(x / 12)

Loop

xl换十二进制 = ss

End Function

然后在excel中就可以正常使用,如