[已解决]求助如何根据绿色区域的小写金额自动转成大写金额到报销单的各个位置.谢谢

qinhuan66

求助如何根据绿色区域的小写金额自动转成大写金额到报销单的各个位置.谢谢
单位费用报销单.zip (127.62 KB, 下载次数: 15)

2014-12-2 15:51 上传

点击文件名下载附件

最佳答案

月排行榜 / 总排行榜

baksy

2014-12-2 16:33

复制以下公式；
E7=IF(Y7<10^5,"X",TEXT(MOD(INT(Y7/10^5),10),"[dbnum2]0"))
G7=IF(Y7<10^4,"X",TEXT(MOD(INT(Y7/10^4),10),"[dbnum2]0"))
J7=IF(Y7<10^3,"X",TEXT(MOD(INT(Y7/10^3),10),"[dbnum2]0"))
L7=IF(Y7<10^2,"X",TEXT(MOD(INT(Y7/10^2),10),"[dbnum2]0"))
O7=IF(Y7<10,"X",TEXT(MOD(INT(Y7/10^1),10),"[dbnum2]0"))
S7=IF(Y7<1,"X",TEXT(MOD(INT(Y7),10),"[dbnum2]0"))
U7=IF(Y7<0.1,"X",TEXT(MOD(INT(Y7/10^-1),10),"[dbnum2]0"))
W7=IF(Y7<0.01,"X",TEXT(MOD(INT(Y7/10^-2),10),"[dbnum2]0"))

跳转到最佳答案楼层

baksy

复制以下公式；
E7=IF(Y7<10^5,"X",TEXT(MOD(INT(Y7/10^5),10),"[dbnum2]0"))
G7=IF(Y7<10^4,"X",TEXT(MOD(INT(Y7/10^4),10),"[dbnum2]0"))
J7=IF(Y7<10^3,"X",TEXT(MOD(INT(Y7/10^3),10),"[dbnum2]0"))
L7=IF(Y7<10^2,"X",TEXT(MOD(INT(Y7/10^2),10),"[dbnum2]0"))
O7=IF(Y7<10,"X",TEXT(MOD(INT(Y7/10^1),10),"[dbnum2]0"))
S7=IF(Y7<1,"X",TEXT(MOD(INT(Y7),10),"[dbnum2]0"))
U7=IF(Y7<0.1,"X",TEXT(MOD(INT(Y7/10^-1),10),"[dbnum2]0"))
W7=IF(Y7<0.01,"X",TEXT(MOD(INT(Y7/10^-2),10),"[dbnum2]0"))

qinhuan66

baksy 发表于 2014-12-2 16:33
E7单元格复制以下公式；
=IF(Y7

谢谢你

baksy

qinhuan66 发表于 2014-12-2 16:37
谢谢你
G7和其他呢?

2楼已有公式。