how can i get an table to look like a formatted table

[Guest]

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]

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.

 

[Guest]

="Name" & REPT(".",18)
is a way...

 

[Guest]

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

 

[Dave Peterson]

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.

 

[Guest]

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]

Select your date cells and give it a format like:

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

(all positive numbers will be treated as dates)

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]

Or maybe:

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


The *. stuff adds the trailing dots.

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.

 

[Guest]

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.

 

[Dave Peterson]

Is there a reply in here?

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.