Dot Leaders

[Richard]

I know there's a custom cell format that I can use to create the equivalent
of a "dot leader" in an Excel Cell but I can't remember what it is.

 

[Mike H]

An example of what a 'Dot leader' looks like please

 

[Dave Peterson]

*.
will give the dot leader.

A couple examples:
*.General
*.$#,##0.00

 

[Richard]

Thanks Dave how can I get this to work with text in a cell? e.g.

Cell 1 Cell2
The quick brown fox..................5678

 

[Gord Dibben]

@*. to have dots follow the text.


*.@ to have dots precede the text



Gord Dibben MS Excel MVP