# 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.

## 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.

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

Check the check box to use thousands separator.

## c) Use accounting specific format

As shown in the figure:

# 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
Display currency symbols
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
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
Display currency symbol
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.

## Why is reids fast

1. What is redis? Redis is completely open source and complies with the BSD protocol. It is a high-performance key value database. Redis is also one of the most popular NoSQL databases at present. It contains a variety of data structures, supports network, is memory based, and has an optional key value pair storage database […]