只需要把下面的G24,换成你需要的单元格即可。
=SUBSTITUTE(SUBSTITUTE(TEXT(INT(G24),"[DBNum2][$-804]G/通用格式元"&IF(INT(G24)=G24,"整",""))&TEXT(MID(G24,FIND(".",G24&".0")+1,1),"[DBNum2][$-804]G/通用格式角")&TEXT(MID(G24,FIND(".",G24&".0")+2,1),"[DBNum2][$-804]G/通用格式分"),"零角","零"),"零分","")
联系客服