EXCEL如何把数字定义成某个英文字母

来源：百度知道 编辑：UC知道 时间：2024/05/11 18:31:20
各位大虾们好
我想请教一下,我想在EXCEL里面 把某个计算的结果定议成 英文字母 如何解决,
比喻就像16进制一样,
假如 8+7=15 但是我要他显示的不是15 而是F 一样的,大家有没有什么方法和这方面的函数,
小弟在这谢谢了

数据输入在a1，比如 重

b1输入
="%"&LOOKUP(INT(CODE(A1) /4096),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15;0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F"})&LOOKUP(INT(MOD(CODE(A1),4096)/256),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15;0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F"})&LOOKUP(INT(MOD(MOD(CODE(A1),4096),256)/16),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15;0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F"})&LOOKUP(MOD(MOD(MOD(CODE(A1),4096),256),16),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15;0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F"})

结果是 %D6D8

其实就是10进制转换为16进制了

我知道可以用函数，上面是我做的例子，不转换16进制 转换任意进制用我的方法都ok，excel提供的只能转换2，8，16进制，15进制还能转换么？

没有奖励不帮忙

谈两点：

1，一楼的同志这样不好，我们要本着乐于助人的态度，为人民排忧解难。再说了，这分还不是一堆虚拟数