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

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


"Dave Peterson" wrote:

*.
will give the dot leader.

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

Richard wrote:

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.

--

Dave Peterson