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.