Thread: leading dots
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
milfordatty milfordatty is offline
external usenet poster
 
Posts: 4
Default 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