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

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?

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

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

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

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

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

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

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

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

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

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

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

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

Select your date cells and give it a format like:

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

(all positive numbers will be treated as dates)

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

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

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

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

"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

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

Is there a reply in here?

Stressed Student wrote:

"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