But if we wanted to supply a range for joining cells with a delimiter (say a comma) then it is really tricky with these functions.

You don't have to click the buttons.So earlier we had CONCAT, and CONCATENATE function to concatenate multiple cells. ** When you type a number with dollar signs and commas, Excel automatically formats the cells for you. Go ahead and experiment with the effects of using the buttons on the Formatting toolbar. The formatting of a cell is separate from its contents. Then you can drag right or left to change the column width, or double-click to make it fit the widest item in the column.Īlthough the numbers have a different appearance, the contents of the cells have not changed.

To widen the column, place the mouse pointer over the right border of the column heading until it turns into a two-headed arrow. When your text is too long to fit within a cell, it extends into a blank column to the right or appears cut off. (Click the Decrease Indent button to reduce the amount of the indent.) Click the Increase Indent button to indent subordinate items from the left edge of the cell. Click the Bold or Italic button to emphasize headings. Click the Underline button to add an underline on the cell above the total. In a budget, you are just estimating dollars, so cents aren't needed. Click the Decrease Decimal button two times to eliminate the decimal places. To correct this, use Comma formatting on the other numbers, even if they are less than 1,000. When you format the top row of numbers with dollar signs, the numbers no longer line up correctly with the other numbers in the column. Click the Comma Style button to add commas to numbers where dollar signs aren't needed. Click the Currency Style button to add dollar signs to the numbers. Here are some you can easily use on a budget.

The Formatting toolbar has lots of buttons you can use to change the appearance of your worksheet. Make some headings stand out by making them bold or italic, and separate numbers from the total by underlining. Add dollar signs to help the reader know you are talking about money, and add commas to make it easy to read numbers over 1,000. Widen columns so that all the text appears. If you've used Word or PowerPoint, several of these buttons are already familiar to you. To do this, you can click buttons on the Formatting toolbar. To make your budget more readable, you must format it, or change its appearance.

You can create a budget in MS Excel and track your expenses.

Excel add commas in numbers