转换成一个天干地支可以这样：
=LOOKUP(MOD(A1-1,10),{0,1,2,3,4,5,6,7,8,9},{"甲","乙","丙","丁","戊","己","庚","辛","壬","癸"})&LOOKUP(MOD(A1-1,12),{0,1,2,3,4,5,6,7,8,9,10,11},{"子","丑","寅","卯","辰","巳","午","未","申","酉","戌","亥"})
如果要达到你的要求，那公式就太长了。
建议一：分两步，首先将6组数字提取到其他单元格，再针对这些单元格进行转换。
建议二：用宏来做。
内容全部来源于网络收集，如有侵权，请联系网站删除！
QQ：24596024