leading dots

[Guest]

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)

 

[Guest]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

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

 

[Guest]

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.

 

[Dave Peterson]

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

 

[Guest]

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

Format|Format Cells|Number|Custom

 

[Guest]

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!!