在EXCL中怎样把小写数字转换成中文大写？

设A列为数据列，则在B1输入以下公式(可复制):

=IF(A1<0,"负","")&IF(ABS(A1)>1,TEXT(TRUNC(ABS(ROUND(A1,2))),"[DBNum2]")&"元","")&IF(ISERR(FIND(".",ROUND(A1,2))),"",TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A1,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(A1,2),3))=".",TEXT(RIGHT(ROUND(A1,2)),"[DBNum2]")&"分","整")

如果数据不在 A1，或在 C1，则用查找替换 把 A1替换成 C1，可表格全选查找替换

本人的百度空间有这一问题的详细解答:
http://hi.baidu.com/qinqh%5Fyl/blog/item/29e1aaef3968a916fdfa3cff.html

单元格格式里有个特殊里面有大小写转换

鼠标右键->设置单元格格式->[特殊]里面有