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.

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

"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.

*.
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

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

@*. to have dots follow the text.


*.@ to have dots precede the text



Gord Dibben MS Excel MVP

On Fri, 25 Jan 2008 16:08:01 -0800, Richard
wrote:

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