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