Or maybe:

mm/dd/yyyy*.;-General;0;@*.


The *. stuff adds the trailing dots.

Stressed Student wrote:

Dave, that worked to repeat the dots but it messed up all my dates and times.
Is there any way to fix that? Thank you so much for your help.

"Dave Peterson" wrote:

Select your cell(s)
format|cells|Number tab
select the custom category
type this in the box to the right:

General*.;-General*.;0*.;@*.

click ok.



Stressed Student wrote:

I cannot get this to work. Could you please be more specific.

"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 setting up a list of marathon records and I want them to display
name.............time................date......... .......location
in a word document. Is there any way to format my Excell Table to
automatically put the period progression between fields?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson