當前位置:股票大全官網 - 股票行情 - words公式中EXCEL金額前面怎麽加符號?

words公式中EXCEL金額前面怎麽加符號?

B1:

= text (c1,"[dbnum2] [$ RMB] g/common format ")

B2:

="?"& amp文本(C2,“[DBNum2][$RMB]G/通用格式”)

B3:

= "¥" & amp;文本(C3,“[DBNum2][$RMB]G/通用格式”)

B4:

= "大寫:" &;文本(C4,“[DBNum2][$RMB]G/通用格式”)