View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JTA JTA is offline
external usenet poster
 
Posts: 1
Default 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.