Using dots in Excel

Posted by Barb Vogelpohl on December 11, 2001 4:34 AM

We are an accounting firm. We type our financial statements in Word using tables. We use dot leadering with our descriptions on our statments, that is after the description, dots lead over to the the money column. In Word, all it takes is setting a right tab with the choice of dots as a leader. We would like to do our statements in Excel, but as yet have found no way to get dots (that line up) from the line description to the beginning of the column containing the numbers. Anyone have any idea of a way to accomplish this?

Posted by Mark W. on December 11, 2001 7:47 AM

For your descriptions use the custom format: @*.
For your dollars use: $* #,##0 (or an equivalent)

Posted by loren on December 12, 2001 5:25 AM

Re: Using dots OR format cell, alignment, horiz., fill