![]() ![]() The above steps would remove the comma from all the selected numbers. Uncheck the ‘Use 1000 Separator (,)’ option and specify how many decimal digits you want.In the Category list, select Number (if not selected already).In the Format Cells dialogue box, make sure the Number tab is selected.In the number group, click on the dialogue box launcher (the small slanted arrow icon at the bottom-right part of the group).Select the dataset (the one with the numbers).Suppose you have a dataset as shown below and you want to get rid of the commas from the numbers in column B. Since these commas are part of the formating and not the number itself, we need to edit the formatting to remove these commas from the numbers. ![]() When working with numbers in Excel, you can apply various formats to the cells and the numbers would be displayed accordingly. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |