How to create a custom number format in Excel to show comma as decimal separator
E.g. instead of 4,100.3
开发者_运维问答 (American) it would be 4 100,3
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.
精彩评论