excel表格中的数字为什么变成英文字母,要怎样转换答:你好!=LOOKUP(A1,{1,"one";2,"two";3,"three";4,"four";5,"five";6,"six";7,"seven";8,"eight";9,"nine";10,"ten"})这个可以把A1单元格的数字1-10转成英语。放在A1以外的单元格。希望能够帮到你!
EXCEL如何把数字定义成某个英文字母答: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,...