Occasionally you may want to produce a column of text and a column of numbers with dots separating the text and the numbers. Here are two methods for producing dot leaders in Excel - one of them may work for you.

Method One:
This method produces dots that go from the left edge of the cell to one space before the number. The dots are in the same cell as the number. If you right-justify your column of text, then apply this number format to the cells containing numbers, it will look like your dots run from the edge of the text right up to the number, like this:

To apply this method, follow these steps:

1. Right-justify your column of text by selecting the column, or the occupied cells in the column, and clicking the Align Right button on your Formatting toolbar (or choosing Format, Cells, Alignment, then choosing Right as the Horizontal alignment, then click OK).

2. Select the column of numbers or the cells containing the numbers to which you want to apply the dot leaders.

3. Choose Format, Cells from the menu, then click the Number tab.

4. Choose Custom from the Category list.

5. In the Type area of the Format Cells window, enter the following:

*._0.00

This code can be translated as follows:

6. Click OK when finished. The new number format will be applied to all selected cells.

Method Two:

If you would prefer, you enter the text left-justified in the first column, then provide dots from the text to the right side of the text column. The dots reside in the same cell as the text. The result will look like this:

To apply this method, follow these steps:

1. Enter your column of text.

2. Select the column of text or the exact cells containing the text to which you want to apply the dots.

3. Choose Format, Cells from the menu, then click the Number tab.

4. Choose Custom from the Category list.

5. In the Type area of the Format Cells window, enter the following:

@ *.

This code can be translated as follows:

6. Click OK when finished. The new number format will be applied to all selected cells.

View more helpful tips!