Office中国论坛/Access中国论坛
标题:
能否把数字直接变大写???
[打印本页]
作者:
lonovo
时间:
2005-9-20 20:56
标题:
能否把数字直接变大写???
[attach]13215[/attach]
作者:
淼漫
时间:
2005-9-21 05:17
其实在论坛中有很多这样的帖子试试在B7中输入:=IF(F6=0,"零元整",IF(F6<0,"负",)&IF(INT(ABS(F6)),TEXT(INT(ABS(F6)),"[dbnum2]")&"元",)&IF(INT(ABS(F6)*10)-INT(ABS(F6))*10,TEXT(INT(ABS(F6)*10)-INT(ABS(F6))*10,"[dbnum2]")&"角",IF(INT(ABS(F6))=ABS(F6),,"零"))&IF(ROUND(ABS(F6)*100-INT(ABS(F6)*10)*10,),TEXT(ROUND(ABS(F6)*100-INT(ABS(F6)*10)*10,),"[dbnum2]")&"分","整"))
作者:
lonovo
时间:
2005-9-21 19:38
谢谢楼上的,谢谢!!!
欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)
Powered by Discuz! X3.3