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

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

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

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

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

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.

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

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

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