例:A1单元格,填入数字50000, 在B1写入="资产总额为"&基本数据!A1&"元"。 现在B1只能显示“资产总额为50000元”。 需要让数字插入千分位,怎么设置可以让B1显示为“资产总额为50,000.00元”? 1、B1="资产总额为"&text(基本数据!A1,"#,0.00")&"元," 2、B1="资产总额为"&TEXT(基本数据!A1,"#,#.#0")&"元," 3、不是负资产可写为:
=TEXT(A1,"资产总额为#,##0.00元, ") =TEXT(A1,"资产总额为#,0.00元, ") |
|