Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to refer to a text piece in a VBA custom function? | Excel Discussion (Misc queries) | |||
HOW to calculate the interest paid between 2 custom periods? | Excel Worksheet Functions | |||
Custom number formats in TEXT function | Excel Worksheet Functions | |||
special formatting adds extra zeroes | Excel Worksheet Functions | |||
Auto Fill Pay Periods | Excel Discussion (Misc queries) |