支票打印、请求帮助

fcwxk · 发表于 2006-2-16 09:21

q8ZvyJ62.rar (6.25 KB, 下载次数: 81)

我单位在信用社开户，我自制现金、转账支票、进账单在激光打印机上打印的文件，遇到几个问题。在附件里用红字写出请各位大虾帮帮忙。

fcwxk · 发表于 2006-2-16 09:26

另外还有一个问题是，在支票和进账单中输入公式，当金额为整数时，如12345.00元,小写金额小数后的两个"0"无法显示。请大家帮一帮。

zzxian · 发表于 2006-3-11 20:35

<P>IF(ROUND(G1,2)=0,"",IF(ROUND(ABS(G1),2)>=1,TEXT(INT(ROUND(ABS(G1),2)),"[DBNum2]")&"元","")&IF(RIGHT(TEXT(G1,".00"),2)*1=0,"整",IF(RIGHT(TEXT(G1,".00"),4)*1>=1,IF(RIGHT(TEXT(G1,".00"),2)*1>9,"","零"),IF(ROUND(ABS(G1),2)>=1,"零",""))&IF(RIGHT(TEXT(G1,".00"),2)*1>9,TEXT(LEFT(RIGHT(TEXT(G1,".00"),2)),"[DBNum2]")&"角","")&IF(RIGHT(TEXT(G1,".00"))*1>0,TEXT(RIGHT(TEXT(G1,".00")),"[DBNum2]")&"分","整")))</P>
<P>这个公式更简单</P>

		自动登录	找回密码
密码			免费注册

[求助] 支票打印、请求帮助