Day of Week and Date in same cell

[icebreaker914]

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

[Norman Jones]

Hi Icebreaker914,

Try:

Selection.NumberFormat = "dddd mm/dd/yyyy"


---
Regards,
Norman



"icebreaker914" <icebreaker914@discussions.microsoft.com> wrote in message
news:29F5C8B6-5663-4A90-BA46-4F40C5D2E2B2@microsoft.com...
> 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

[William Benson]

set number format to:

"dddd mmmm d, yyyy"

"icebreaker914" <icebreaker914@discussions.microsoft.com> wrote in message
news:29F5C8B6-5663-4A90-BA46-4F40C5D2E2B2@microsoft.com...
> 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]

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

[William Benson]

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" <ec35720@netscapeXSPAM.com> wrote in message
news:42ABAA30.180B0803@netscapeXSPAM.com...
> 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

[Bob Phillips]

"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:42ABAA30.180B0803@netscapeXSPAM.com...
> 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]

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" <ec35720@netscapeXSPAM.com> wrote in message
> news:42ABAA30.180B0803@netscapeXSPAM.com...
> > 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

[Dave Peterson]

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" <ec35720@netscapeXSPAM.com> wrote in message
> news:42ABAA30.180B0803@netscapeXSPAM.com...
> > 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

[icebreaker914]

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" <ec35720@netscapeXSPAM.com> wrote in message
> > news:42ABAA30.180B0803@netscapeXSPAM.com...
> > > 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
>