Select the cells in which you want the dots
Choose FormatCells
On the Number tab, choose Custom
In the text box, type: @*.
Click OK

wstock3 wrote:
If you look at financial data you will see that there is often a leader
(dotted underline), between a field name or catagory and the data that it is
referencing. An example:

Region Revenue
Boston..........$100,000.00

I am trying to determine how to do this in excel. I do not want to
underline the entire cell. I want the leader to start at the end of the word
an go to the end of the cell.

Any help is appreciated - Thanks!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html