如何在Excel中创建自定义数字格式以将逗号显示为小数分隔符(How to create a custom number format in Excel to show comma as decimal separator)

例如，而不是4,100.3 （美国），它将是4 100,3

E.g. instead of 4,100.3 (American) it would be 4 100,3

最满意答案

转到Tools - Options - International Tab (or Advanced if using Office 2010) - Separators （取消选中“使用系统分隔符” - 并放入你想要的分隔符。

Go to Tools - Options - International Tab (or Advanced if using Office 2010) - Separators (uncheck "use system separators" - and put in what you want as separators.

更多推荐