leading dots
 

I want to add a leading dot to a cell so that it leads a bunch of dots to the
next cell. For example (hoping and assuming this will display correctly on
this post):

Cost for cleanup 8/28/2007.................................. $250.00

(where $250.00 is the next cell)

leading dots
 

although you can use a custom format like "m/d/yyyy....................." I
don't think that would be very useful. I presume you want the last dot to end
very close to the next cell, but if the column with is not big enough you
would get ######.
Perhaps a combination of the above custom format and right aligning would
get the best result.
rdwj

"milfordatty" wrote:

I want to add a leading dot to a cell so that it leads a bunch of dots to the
next cell. For example (hoping and assuming this will display correctly on
this post):

Cost for cleanup 8/28/2007.................................. $250.00

(where $250.00 is the next cell)

leading dots
 

If you are not Michelle, then see my reply to her posted one minute before
your request.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"milfordatty" wrote in message
...
I want to add a leading dot to a cell so that it leads a bunch of dots to
the
next cell. For example (hoping and assuming this will display correctly
on
this post):

Cost for cleanup 8/28/2007.................................. $250.00

(where $250.00 is the next cell)

leading dots
 

I am confuse about who "Michelle" is and cannot find your reply to her
(whoever she is). Sorry.

"Sandy Mann" wrote:

If you are not Michelle, then see my reply to her posted one minute before
your request.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"milfordatty" wrote in message
...
I want to add a leading dot to a cell so that it leads a bunch of dots to
the
next cell. For example (hoping and assuming this will display correctly
on
this post):

Cost for cleanup 8/28/2007.................................. $250.00

(where $250.00 is the next cell)

leading dots
 

Although that would work, that would be a tedious task (to do that for every
line). I am trying to do this on a sheet full of items just to make reading
accross the line a little easier.

Word has this feathure and I use it a lot. Problem with the feature in Word
is that it is part of the Tab formatting and it's very tricky to get it into
a table in Word.

I was just hoping that there was some function in Excel that would allow this.

Thank you for your help.

"rdwj" wrote:

although you can use a custom format like "m/d/yyyy....................." I
don't think that would be very useful. I presume you want the last dot to end
very close to the next cell, but if the column with is not big enough you
would get ######.
Perhaps a combination of the above custom format and right aligning would
get the best result.
rdwj

"milfordatty" wrote:

I want to add a leading dot to a cell so that it leads a bunch of dots to the
next cell. For example (hoping and assuming this will display correctly on
this post):

Cost for cleanup 8/28/2007.................................. $250.00

(where $250.00 is the next cell)

leading dots
 

Do you just have a date in that cell?

If yes:
Try Format|Cells|number tab|custom category:
"Cost for cleanup " m/d/yyyy*.

If the cell really contains: Cost for cleanup 8/28/2007
use a custom format of: @*.






milfordatty wrote:

I want to add a leading dot to a cell so that it leads a bunch of dots to the
next cell. For example (hoping and assuming this will display correctly on
this post):

Cost for cleanup 8/28/2007.................................. $250.00

(where $250.00 is the next cell)

--

Dave Peterson

leading dots
 

Try this custom format
*.$#,##0_);*.($#,##0)

Format|Format Cells|Number|Custom
--
HTH...

Jim Thomlinson


"milfordatty" wrote:

I want to add a leading dot to a cell so that it leads a bunch of dots to the
next cell. For example (hoping and assuming this will display correctly on
this post):

Cost for cleanup 8/28/2007.................................. $250.00

(where $250.00 is the next cell)

leading dots
 

that did it! the cells were a mixture of text and numbers/dates (like an
invoice might be) so I used @*. and it worked PERFECTLY!! THANKS!!


"Dave Peterson" wrote:

Do you just have a date in that cell?

If yes:
Try Format|Cells|number tab|custom category:
"Cost for cleanup " m/d/yyyy*.

If the cell really contains: Cost for cleanup 8/28/2007
use a custom format of: @*.






milfordatty wrote:

I want to add a leading dot to a cell so that it leads a bunch of dots to the
next cell. For example (hoping and assuming this will display correctly on
this post):

Cost for cleanup 8/28/2007.................................. $250.00

(where $250.00 is the next cell)

--

Dave Peterson