Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day of Week and Date in same cell
Is it possible to list the day of week and calendar date in the same cell?
If any one can help out it would be greatly appreciated! -- icebreaker914 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day of Week and Date in same cell
Hi Icebreaker914,
Try: Selection.NumberFormat = "dddd mm/dd/yyyy" --- Regards, Norman "icebreaker914" wrote in message ... Is it possible to list the day of week and calendar date in the same cell? If any one can help out it would be greatly appreciated! -- icebreaker914 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day of Week and Date in same cell
set number format to:
"dddd mmmm d, yyyy" "icebreaker914" wrote in message ... Is it possible to list the day of week and calendar date in the same cell? If any one can help out it would be greatly appreciated! -- icebreaker914 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day of Week and Date in same cell
Just a couple of variations:
dddd* mm/dd/yyyy (watch what happens when you widen the column.) And dddd(alt-0010)mm/dd/yyyy And center it in the cell, and turn wrap text on. You'll have to adjust the rowheight manually (and don't make the columnwidth too skinny!) (for (alt-0010), hit and hold the alt key while typing 0010 on the numeric keypad. You should see a little square for that character--until you turn on wrap text.) icebreaker914 wrote: Is it possible to list the day of week and calendar date in the same cell? If any one can help out it would be greatly appreciated! -- icebreaker914 -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day of Week and Date in same cell
I typed dddd(alt-0010)mm/dd/yyyy in Custom area and got a message that it is
an invalid format. Excel 2000. "Dave Peterson" wrote in message ... Just a couple of variations: dddd* mm/dd/yyyy (watch what happens when you widen the column.) And dddd(alt-0010)mm/dd/yyyy And center it in the cell, and turn wrap text on. You'll have to adjust the rowheight manually (and don't make the columnwidth too skinny!) (for (alt-0010), hit and hold the alt key while typing 0010 on the numeric keypad. You should see a little square for that character--until you turn on wrap text.) icebreaker914 wrote: Is it possible to list the day of week and calendar date in the same cell? If any one can help out it would be greatly appreciated! -- icebreaker914 -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day of Week and Date in same cell
"Dave Peterson" wrote in message ... And dddd(alt-0010)mm/dd/yyyy And center it in the cell, and turn wrap text on. 'Problem' with that is that the cell still needs to be as wide as if there were no text wrapping, which loses the point somewhat. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day of Week and Date in same cell
But if it were used as a header, it might not be a problem--if the data in that
column was wider. Bob Phillips wrote: "Dave Peterson" wrote in message ... And dddd(alt-0010)mm/dd/yyyy And center it in the cell, and turn wrap text on. 'Problem' with that is that the cell still needs to be as wide as if there were no text wrapping, which loses the point somewhat. -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day of Week and Date in same cell
Did you type (alt-0010) or did you hit and hold the alt-key while typing 0010
from the number keypad? William Benson wrote: I typed dddd(alt-0010)mm/dd/yyyy in Custom area and got a message that it is an invalid format. Excel 2000. "Dave Peterson" wrote in message ... Just a couple of variations: dddd* mm/dd/yyyy (watch what happens when you widen the column.) And dddd(alt-0010)mm/dd/yyyy And center it in the cell, and turn wrap text on. You'll have to adjust the rowheight manually (and don't make the columnwidth too skinny!) (for (alt-0010), hit and hold the alt key while typing 0010 on the numeric keypad. You should see a little square for that character--until you turn on wrap text.) icebreaker914 wrote: Is it possible to list the day of week and calendar date in the same cell? If any one can help out it would be greatly appreciated! -- icebreaker914 -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day of Week and Date in same cell
It worked great for me! Thanks for the help!
-- icebreaker914 "Dave Peterson" wrote: Did you type (alt-0010) or did you hit and hold the alt-key while typing 0010 from the number keypad? William Benson wrote: I typed dddd(alt-0010)mm/dd/yyyy in Custom area and got a message that it is an invalid format. Excel 2000. "Dave Peterson" wrote in message ... Just a couple of variations: dddd* mm/dd/yyyy (watch what happens when you widen the column.) And dddd(alt-0010)mm/dd/yyyy And center it in the cell, and turn wrap text on. You'll have to adjust the rowheight manually (and don't make the columnwidth too skinny!) (for (alt-0010), hit and hold the alt key while typing 0010 on the numeric keypad. You should see a little square for that character--until you turn on wrap text.) icebreaker914 wrote: Is it possible to list the day of week and calendar date in the same cell? If any one can help out it would be greatly appreciated! -- icebreaker914 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
How to format a cell from date to week? | Excel Discussion (Misc queries) | |||
I want to highlight a column if the date in cell #4 is this week. | Excel Worksheet Functions | |||
How do I get a cell to show the day of the week when date entered | Excel Discussion (Misc queries) | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) |