Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Excel 公式

如果在B1格設一個公式

="股數"&A1&"股"

這樣我在A1打12345678

B1會顯示 [股數12345678股]

我可以讓它顯示為 [股數12,345,678股]嗎?

就是希望有千分位符號

2 Answers

Rating
  • lmf
    Lv 5
    8 years ago
    Favorite Answer

      A 1 12345678 2   3 股數12,345,678股 ="股數"&FIXED(A1,0)&"股"

  • 老夥
    Lv 7
    8 years ago

    格式/自訂/輸入 "股數"#,##0"股"

    2013-02-07 07:13:28 補充:

    B1自訂上述格式,然後=A1再下拉即可。

Still have questions? Get your answers by asking now.