Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Pivot Table keep apart cells text that I've formatted as numbers | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
I am having trouble keeping numbers formatted in a Pivot Table | Excel Discussion (Misc queries) | |||
Conversion of Cross-Tab Formatted data to qualify for Pivot Table | Excel Discussion (Misc queries) |