Day date format

A

Anthony

Using the custom date format I got from these forms, which works great thank
you.
dddd mmmm d, yyyy I of course get the correct results. My question is can I
use a date format that would put the day of the week over the date.

Friday
September 10, 2004

Thanks for any replies in advance.
 
A

Anthony

I may be asking a little too much here, but if I name a sheet using a date.
For instance, 09-10-04 would there be a formula that would take that name and
insert it into a specific cell using the format dddd mmmm d, yyyy
 
D

Dave Peterson

You can use a custom format of:

dddd_mmmm dd, yyyy

But don't type the underscore--instead, hit and hold the alt key and type 0010
from the numeric keypad--not the numbers above the QWERTY keys.

And make sure that the cell is set for wordwrap.

But you'll have to resize the rowheight manually. And if you make the
columnwidth too small, you'll get ####'s. And too small is based on what it
looks like--it's based on that whole string--just like if it were on one line.

It might look better if you used a formula:

=text(a1,"dddd")&char(10)&text(a1,"mmmm dd, yyyy")
 
R

RagDyer

It can be done with a custom format.

FIRST:
<Format> <Cells> <Alignment> tab,
In the "Horizontal" AND "Vertical" box, expand them and choose "Center" for
both,
And then check "WrapText".

Then:
<Number> tab,
Click "Custom" in the left window, and then in the "Type" box,
Enter:
dddd
Then hold down the <Alt> key,
And using the num keypad (*not* the numbers under the function keys), enter
0010
Then enter
mmmm d, yyy
And then <OK>.

This should give you what you're looking for.

If the date is still on one line, and you see a white square in the cell,
between the day and month, you forgot to check "WrapText".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
and


I may be asking a little too much here, but if I name a sheet using a date.
For instance, 09-10-04 would there be a formula that would take that name
and
insert it into a specific cell using the format dddd mmmm d, yyyy
 
A

Anthony G of La Quinta

Thanks to you both, it worked perfectly!

Dave Peterson said:
You can use a custom format of:

dddd_mmmm dd, yyyy

But don't type the underscore--instead, hit and hold the alt key and type 0010
from the numeric keypad--not the numbers above the QWERTY keys.

And make sure that the cell is set for wordwrap.

But you'll have to resize the rowheight manually. And if you make the
columnwidth too small, you'll get ####'s. And too small is based on what it
looks like--it's based on that whole string--just like if it were on one line.

It might look better if you used a formula:

=text(a1,"dddd")&char(10)&text(a1,"mmmm dd, yyyy")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top