Felix
Reputation: 821
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
Upvotes: 3
Views: 2806
Answers (1)
Mrchief
Reputation: 76208
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.
Upvotes: 7
Related Questions
- VBA number formatting (with commas as decimal separator)
- How to get an Excel cell format number without comma when it's an integer and with two digit after comma when it's a float?
- How do I add in a comma between numbers in excel?
- How can I add a comma & space after every two digits in Excel and then format the text?
- How can I change the decimal separator from "." to "," only for a specific cell using Excel?
- Excel | How to Format Number with comma separated
- Excel: Custom Number Format
- Add a comma after certain digits in Excel
- Custom number format: comma preceding last two digits
- Custom number format in Excel