View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Repeating Characters in Cells with info.

Follow ups in first thread.

Stressed Student wrote:

This is exactly what I want to do, but I am not quite understanding how I can
do that.

"Dave Peterson" wrote:

You could give the cells a custom format of:

General*.;-General*.;0*.;@*.
Positive;negative;0;text

The *. says to repeat the dot enough to fill the cell (to the right).

You may not want it on the numbers, though.

Stressed Student wrote:

I am trying to repeat a period to connect every column in a list of marathon
records. I want it to read
name.............time..............date........... ....location. how do i
write the formula to do this?


--

Dave Peterson


--

Dave Peterson