1005678金额大写怎么说壹佰万伍仟陆佰柒拾捌呢还是壹佰万零伍仟陆佰柒拾捌 或者2个都可以?
第1个回答 2010-11-13
壹、贰、叁、肆、伍、陆、柒、捌、玖、拾、佰、仟、万、亿、元、角、分、零
拾贰亿叁仟肆佰伍拾陆万柒仟捌佰玖拾元整
拾贰亿叁仟肆佰伍拾陆万柒仟捌佰玖拾元壹角贰分
答案补充
不好意思,第二个更正一下。拾贰亿叁仟肆佰伍拾陆万柒仟捌佰玖拾元零壹角贰分本回答被提问者采纳
拾贰亿叁仟肆佰伍拾陆万柒仟捌佰玖拾元整
拾贰亿叁仟肆佰伍拾陆万柒仟捌佰玖拾元壹角贰分
答案补充
不好意思,第二个更正一下。拾贰亿叁仟肆佰伍拾陆万柒仟捌佰玖拾元零壹角贰分本回答被提问者采纳
第2个回答 2010-11-12
壹佰万伍仟陆佰柒拾捌,只有这个可以。其实这是小学的读数问题
第3个回答 2010-10-30
都可以的
第4个回答 2010-10-30
壹佰万零伍仟陆佰柒拾捌 更确切点。当然、两者都可以
第5个回答 2010-10-30
公式吗?
假设J12为阿拉伯金额
公式为=IF(J12<0,"(负)"&IF(ABS(J12)<1,"",TEXT(INT(ABS(J12)),"[dbnum2]")&"元")&IF(MOD(INT(ABS(J12*10)),10)=0,IF(INT(ABS(J12))*MOD(INT(ABS(J12*100)),10)=0,"","零"),TEXT(MOD(INT(ABS(J12*10)),10),"[dbnum2]")&"角")&IF(MOD(INT(ABS(J12*100)),10)=0,"整",TEXT(MOD(INT(ABS(J12*100)),10),"[dbnum2]")&"分"),IF(J12=0,"零",IF(J12<1,"",TEXT(INT(J12),"[dbnum2]")&"元")&IF(MOD(INT(J12*10),10)=0,IF(INT(J12)*MOD(INT(J12*100),10)=0,"","零"),TEXT(MOD(INT(J12*10),10),"[dbnum2]")&"角")&IF(MOD(INT(J12*100),10)=0,"整",TEXT(MOD(INT(J12*100),10),"[dbnum2]")&"分")))
假设J12为阿拉伯金额
公式为=IF(J12<0,"(负)"&IF(ABS(J12)<1,"",TEXT(INT(ABS(J12)),"[dbnum2]")&"元")&IF(MOD(INT(ABS(J12*10)),10)=0,IF(INT(ABS(J12))*MOD(INT(ABS(J12*100)),10)=0,"","零"),TEXT(MOD(INT(ABS(J12*10)),10),"[dbnum2]")&"角")&IF(MOD(INT(ABS(J12*100)),10)=0,"整",TEXT(MOD(INT(ABS(J12*100)),10),"[dbnum2]")&"分"),IF(J12=0,"零",IF(J12<1,"",TEXT(INT(J12),"[dbnum2]")&"元")&IF(MOD(INT(J12*10),10)=0,IF(INT(J12)*MOD(INT(J12*100),10)=0,"","零"),TEXT(MOD(INT(J12*10),10),"[dbnum2]")&"角")&IF(MOD(INT(J12*100),10)=0,"整",TEXT(MOD(INT(J12*100),10),"[dbnum2]")&"分")))