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

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.

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

FormatCellsNumberCustom

@*.

That is @ asterisk dot(no spaces)

A handy macro.

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


Gord Dibben MS Excel MVP


On Tue, 1 Apr 2008 12:17:02 -0700, JTA wrote:

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.