Special custom fill function which adds periods at the end of text

[JTA]

I use to prepare a financial report with text in one column and numbers in
the second column. As a result of the amount of blank space between the text
to the end of the column (before the column with the number), I use to know a
special code which automatically added periods (.......) to fill up the cell
to end of the column. I am looking to find out what that custom code is to
permit me to automatically add those periods at the end of each text field:
For Example:
Cash....................................... $2,000
Accounts Receivable................. 4,500,
etc.

 

[Gord Dibben]

Format>Cells>Number>Custom

@*.

That is @ asterisk dot(no spaces)

A handy macro.

Sub Leaders()
Selection.NumberFormat = "@*."
End Sub


Gord Dibben MS Excel MVP