and select a cell to place the split values.Īdd comma at end of cell/text with Kutools for Excel Select the range you want to add comma after text.Customize format dialogue box will appear.A region dialogue box will appear, click on additional setting.Open the region setting in control penal.
Then double click on the control panel.To get 100,000 as 1,00,000 in MS Excel with the following steps After the Format Cells dialog box opens, click the Custom option to get to the screen shown in this figure. To show your numbers in thousands, highlight them, right-click, and select Format Cells. Commonly “thousands separator” is the name of the comma in this format that doesn’t translate nicely to an adjective, so perhaps you could rephrase your statement slightly to tell them to use “numbers with thousands separators” (rather than the clumsy “thousands separated numbers”).
0 kommentar(er)
