Excel custom format thousand separator

Time:2022-2-24
Reading time |0.64 minutes word count |1028 characters
primary coverage |1. Introduction & background
“Excel custom format thousand separator”
Author | Writing time | 2021/12/19 AM12:9
Article type |Series Degree of completion |Completed
motto Every great cause has a trivial beginning.

1、 Introduction & backgroundDegree of completion: 100%


a) Dealing with problems

How to set the thousand separator using the custom format set by Excel cells? Bloggers study this problem because they write code using aspese The cell formatting function of cells achieves the effect of thousand separator.

b) Expected effect & solution

Set the format to custom in Aspose.

Excel custom format thousand separator
Excel custom format thousand separator

c) Application scenario

  • Aspose. Cells realize the thousand separator:#,##0How to customize.
/// 
        /// Percentage 0%
        /// 
        public static string Percentage1 = "0%";
        /// 
        /// Percentage 0.00%
        /// 
        public static string Percentage2 = "0.00%";
        /// 
        ///Thousand separator
        /// 
        public static string OneThousandSeparate = "#,##0";

2、 Three methods of Excel directly processing thousand separatorDegree of completion: 100%


a) Shortcut Ctrl + Shift +!

The effect is to change to currency format.

Excel custom format thousand separator

b) CTRL + 1 select the cell and set the value to use the thousand separator

Check the check box to use thousands separator.

Excel custom format thousand separator

c) Use accounting specific format

As shown in the figure:

Excel custom format thousand separator

3、 Custom format in-depth learningDegree of completion: 100%


a) Learning entrance

Dedicated to users in-depth use, the customized expression is very powerful. Please enter the learning portalClick here

b) Included sections (EN)

How to create an Excel custom number format
Understanding Excel number format
Excel formatting tips and guidelines
Show the desired number of decimal places
Display a thousand separator
Round numbers by thousands
Add text to number formats
Display currency symbols
Show leading zeros
Display numbers as percentages
Turn decimal numbers into fractions
Create a custom Scientific Notation format
Show negative numbers in parenthesis
Display zeros as dashes or blanks
Add indents
Change font color
Repeat characters
Change alignment
Create conditional number formats
Date and time formats

c) Including chapters (CN)

How to create an excel custom number format
Understand excel number format
Tips and guidelines for Excel format
Displays the desired number of decimal places
Show a thousand separators
Kilobit integer
Add text to number format
Display currency symbol
show leading zero
Display numbers as a percentage
Change decimals into fractions
Create a custom scientific symbol format
Show negative numbers in parentheses
Display zeros as dashes or spaces
Increase Indent
Change font color
Repeat character
Change alignment
Create conditional number format
Date and time format

4、 Statements and referencesDegree of completion: 100%


Original blog post, please do not reprint without permission.

If you are helpful, you are welcome to like, collect and pay attention. If you have any questions, please comment! If you need to contact the blogger, you can write scschero directly.