EXCEL中如果使每次打印自动生成单号,而不用手动去更改?答:上面的方法好象只能是用VBA方法,如果不熟悉VBA,比较麻烦,需要QQ直接教了。第二个可用公式=IF(ROUND(A1,2)<0,"无效数值",IF(ROUND(A1,2)=0,"零",IF(ROUND(A1,2)<1,"",TEXT(INT(ROUND(A1,2)),"[dbnum2]")&"元")&IF(INT(ROUND(A1,2)*10)-INT(ROUND(A1,2))*10=0,IF(INT(...
EXCEL中如果使每次打印自动生成单号,而不用手动去更改?答:上面的方法好象只能是用VBA方法,如果不熟悉VBA,比较麻烦,需要QQ直接教了。第二个可用公式=IF(ROUND(A1,2)<0,"无效数值",IF(ROUND(A1,2)=0,"零",IF(ROUND(A1,2)<1,"",TEXT(INT(ROUND(A1,2)),"[dbnum2]")&"元")&IF(INT(ROUND(A1,2)*10)-INT(ROUND(A1,2))*10=0,IF(INT(...