请教，如何让一组数据金额，转换成大写的，求公式

转换成大写有很多类型，你要种类型?举个例吧!

=IF(G10<1,IF(G10<0.1,TEXT(INT(G10*100),"[DBNum2]G/通用格式")&"分",IF((INT(G10*100)-INT(G10*10)*10=0),TEXT(INT(G10*10),"[DBNum2]G/通用格式")&"角整",TEXT(INT(G10*10),"[DBNum2]G/通用格式")&"角"&TEXT(INT(G10*100)-INT(G10*10)*10,"[DBNum2]G/通用格式")&"分")),TEXT(INT(G10),"[DBNum2]G/通用格式"&"元")&IF((INT(G10*10)-INT(G10)*10)=0,IF((INT(G10*100)-INT(G10*10)*10)=0,"","零"),IF((INT(G10*0.1)-INT(G10)*0.1)=0,"零","")&TEXT(INT(G10*10)-INT(G10)*10,"[DBNum2]G/通用格式")&"角")&IF((INT(G10*100)-INT(G10*10)*10)=0,"整",TEXT(INT(G10*100)-INT(G10*10)*10,"[DBNum2]G/通用格式")&"分"))
G10单元格是小写100，把上面的公式放在需要显示大写的单元格里