如何将阿拉佰数字转化为大写,并能量示为元角分.

小写换成大写，不用手工写，用公式自动填充
=SUBSTITUTE(SUBSTITUTE(IF(B2<0,"负","")&TEXT(TRUNC(ABS(ROUND(B2,2))),"[DBNum2]")&"元"&IF(ISERR(FIND("",ROUND(B2,2))),"",TEXT(RIGHT(TRUNC(ROUND(B2,2)10)),"[DBNum2]"))&IF(ISERR(FIND("0",TEXT(B2,"000"))),"角","")&IF(LEFT(RIGHT(ROUND(B2,2),3))="",TEXT(RIGHT(ROUND(B2,2)),"[DBNum2]")&"分",IF(ROUND(B2,2)=0,"","整")),"零元零",""),"零元","")

大写金额数字应用正楷或行书填写，如壹（壹）、贰（贰）、叁、肆（肆）、伍（伍）、陆（陆）、柒、捌、玖、拾、佰、仟、万（万）、亿、元、角、分、零、整（正）等字样。不得用一、二（两）、三、四、五、六、七、八、九、十、念、毛、另（或0）填写，不得自造简化字。
陆佰元整

---