leading dots

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
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
 
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
 
I am confuse about who "Michelle" is and cannot find your reply to her
(whoever she is). Sorry.
 
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.
 
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: @*.
 
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!!
 
Back
Top