I am trying to make leader dots between cells as seamless as possible and
right now there is a gap showing up.

The custom format I used was @*. and *.# and they worked fine, now I would
just like to eliminate the gap between the two and I'll be set.

Here is a screenshot of what I am trying to say:
http://i10.tinypic.com/7xnpbeu.png

I get no gap when using the @*. with text and a gap using *.# with numerics
only when the first digit is a 1.

I don't think you can prevent that.


Gord Dibben MS Excel MVP

On Mon, 17 Dec 2007 23:36:54 -0600, Ty wrote:

I am trying to make leader dots between cells as seamless as possible and
right now there is a gap showing up.

The custom format I used was @*. and *.# and they worked fine, now I would
just like to eliminate the gap between the two and I'll be set.

Here is a screenshot of what I am trying to say:
http://i10.tinypic.com/7xnpbeu.png

Just enter text in the left column and right justify it.
Format your dots *only* in the right column.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ty" wrote in message
...
I am trying to make leader dots between cells as seamless as possible and
right now there is a gap showing up.

The custom format I used was @*. and *.# and they worked fine, now I would
just like to eliminate the gap between the two and I'll be set.

Here is a screenshot of what I am trying to say:
http://i10.tinypic.com/7xnpbeu.png

If you would be able to use 2 helper columns, in an out-of-the-way location,
say Columns Y and Z, enter your text and numbers there.

Then in say Columns A and B,
Format A to Left Justify,
And B to Right Justify.

Then in Column A:

=Y1&REPT(".",255)

And in Column B:

=REPT(".",255)&Z1

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
Just enter text in the left column and right justify it.
Format your dots *only* in the right column.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ty" wrote in message
...
I am trying to make leader dots between cells as seamless as possible and
right now there is a gap showing up.

The custom format I used was @*. and *.# and they worked fine, now I
would
just like to eliminate the gap between the two and I'll be set.

Here is a screenshot of what I am trying to say:
http://i10.tinypic.com/7xnpbeu.png

I still can see a "seam" between the columns in some of the rows.

You might try putting your 2 columns of text into a *single* presentation
column to eliminate any seams.

Set A1 to the desired (estimated) width to accommodate both entries.
Now, just enter dots to fill the entire cell.
In B1, count the dots with this formula:
=Len(A1)

Say you get a count of 75.

Enter this in A1:

=Y1&REPT(".",75-LEN(Y1)+LEN(Z1))&Z1

Copy down a few rows and see if all the data is visible.

If not, just play with the "75" to get the display you need.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
If you would be able to use 2 helper columns, in an out-of-the-way
location, say Columns Y and Z, enter your text and numbers there.

Then in say Columns A and B,
Format A to Left Justify,
And B to Right Justify.

Then in Column A:

=Y1&REPT(".",255)

And in Column B:

=REPT(".",255)&Z1

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
Just enter text in the left column and right justify it.
Format your dots *only* in the right column.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ty" wrote in message
...
I am trying to make leader dots between cells as seamless as possible and
right now there is a gap showing up.

The custom format I used was @*. and *.# and they worked fine, now I
would
just like to eliminate the gap between the two and I'll be set.

Here is a screenshot of what I am trying to say:
http://i10.tinypic.com/7xnpbeu.png

Darn ... forgot the parens:

=Y1&REPT(".",67-(LEN(Y1)+LEN(Z1)))&Z1

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RagDyer" wrote in message
...
I still can see a "seam" between the columns in some of the rows.

You might try putting your 2 columns of text into a *single* presentation
column to eliminate any seams.

Set A1 to the desired (estimated) width to accommodate both entries.
Now, just enter dots to fill the entire cell.
In B1, count the dots with this formula:
=Len(A1)

Say you get a count of 75.

Enter this in A1:

=Y1&REPT(".",75-LEN(Y1)+LEN(Z1))&Z1

Copy down a few rows and see if all the data is visible.

If not, just play with the "75" to get the display you need.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
If you would be able to use 2 helper columns, in an out-of-the-way
location, say Columns Y and Z, enter your text and numbers there.

Then in say Columns A and B,
Format A to Left Justify,
And B to Right Justify.

Then in Column A:

=Y1&REPT(".",255)

And in Column B:

=REPT(".",255)&Z1

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
Just enter text in the left column and right justify it.
Format your dots *only* in the right column.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
!
---------------------------------------------------------------------------
"Ty" wrote in message
...
I am trying to make leader dots between cells as seamless as possible
and
right now there is a gap showing up.

The custom format I used was @*. and *.# and they worked fine, now I
would
just like to eliminate the gap between the two and I'll be set.

Here is a screenshot of what I am trying to say:
http://i10.tinypic.com/7xnpbeu.png

Oh man, you are awesome, this is exactly what I was hoping for, I couldn't
get the "75" to be consistent, every cell had to be a different number and
it finally dawned on me to use a monospace font, such as courier. Once I
did that, it was smooth sailing.

Once again RD, I can't thank you enough. This is awesome.

"RagDyer" wrote:

Darn ... forgot the parens:

=Y1&REPT(".",67-(LEN(Y1)+LEN(Z1)))&Z1