要用公式,我当年设的给你参考一下:
假设该数字在A1格,加辅助格B1,C1
B1=RMB(A1,2)
C1=LEN(B1)
(以上两个辅助格不是必须,我主要是不想下面的公式太长,特意加的,等于变量哈)
分位=IF(A1<>0,LEFT(RIGHTB($B1,1),1),"")
角位=IF(A1>4,LEFT(RIGHTB($B1,2),1),"")
个位=IF(C1>4,IF(C1=5,IF(INT(A1)=0,"¥",LEFT(RIGHTB($B1,4),1)),LEFT(RIGHTB($B1,4),1)),"")
十位=IF(C1=5,IF(INT(A1)<>0,"¥",""),IF(C1>5,LEFT(RIGHTB($B1,5),1),""))
百位=IF(C1=6,"¥",IF(C1>6,LEFT(RIGHTB($B1,6),1),""))
千位=IF(C1=7,"¥",IF(C1>7,LEFT(RIGHTB($B1,8),1),""))
万位=IF(C1=9,"¥",IF(C1>8,LEFT(RIGHTB($B1,9),1),""))
十万位=IF(C1=10,"¥",IF(C1>9,LEFT(RIGHTB($B1,10),1),""))
百万位=IF(C1=11,"¥",IF(C1>12,LEFT(RIGHTB($B1,12),1),""))
千万位=IF(C1=13,"¥",IF(C1>13,LEFT(RIGHTB($B1,13),1),""))
亿位=IF(C1=14,"¥",IF(C1>14,LEFT(RIGHTB($B1,14),1),""))
因为我当时还要识别自动在前一位加¥,所以复杂了一点,你参考一下吧
温馨提示:答案为网友推荐,仅供参考