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會顯示 [股數12345678股]

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


2 Answers

  • 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 補充:


Still have questions? Get your answers by asking now.