CODEWITHSUNDEEP
excelexcel-formulaexcel-2010ms-office
user3739882
user3739882

Reputation: 11

Excel | How to Format Number with comma separated

How to format excel cell with comma separated. For example, we say like 1427322 and it show like 1,427,322 Any suggestion how we can achieve this?

Upvotes: 1

Views: 3397

Answers (1)

Harsha W
Harsha W

Reputation: 3366

Try this... This worked for me..

Go to Control Panel -> Region (Region & Language) -> In Formats Set format to English(India).

Then apply this custom number format to the specific cell in excel

Apply a custom number format Select the cell or range of cells that you want to format. On the Home tab, under Number, on the Number Format pop-up menu , click Custom. In the Format Cells dialog box, under Category, click Custom. At the bottom of the Type list, select the built-in format that you just created. Click OK.

_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)

Demo

Upvotes: 1

Related Questions