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

  • Thread starter Stressed Student
  • Start date
S

Stressed Student

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?
 
D

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.
 
D

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.
 
S

Stressed Student

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.
 
D

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)

Stressed said:
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.
Click to expand...
 
D

Dave Peterson

Or maybe:

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


The *. stuff adds the trailing dots.

Stressed said:
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.
Click to expand...
 
S

Stressed Student

Dave Peterson said:
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.
Click to expand...
 
Top