Then right click on the table and select Format Cells… in the drop-down list. , comma followed by an asterisk sign) Leave the ‘Replace with’ field empty. 0417 that is limit the maximum number of decimal digits but not set the minimum one, allowing it to be 0 or more as needed. Hi redlyst, You can try the Text () function to format numbers using commas and periods.One may also ask, how do you put a comma after 2 digits in Excel? You can use the variables LEFT and RIGHT to select certain characters from a cell, and then the '&' symbol to concatenate them.For example, you can use Excel to calculate the percentage of correct answers on a test, discount prices using various percent assumptions, or percent change between two values. How to put comma after 2 digits in excel ) Hope this makes sense.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |