Adding the DAY to a Date field?

Dave,

I couldn't get the Alt-0010 to work. It drops to a second line in the
custom format box as you would expect (I have to arrow up and down -- it
only shows one line at a time in that box). But it just puts a square in
the cell where the 0010 code was in the format code. XL2002.


--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave Peterson" wrote in message
...
I really like to use the 4 digit year, too!

and one mo

dddd[alt-0010]mm/dd/yyyy

where [alt-0010] is not typed. Hit and hold the alt-key and type 0010
from the
numeric keypad.

It looks nice centered in the cell--but it doesn't behave very nicely with
autofitting rows or columns.

Looks kind of like this:

Sunday
06/13/2004




Earl Kiosterud wrote:

And try these.

dddd *- dd/mm/yy
dddd ** dd/mm/yy
dddd *. dd/mm/yy
dddd*.dd/mm/yy

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave Peterson" wrote in message
...
One more format that I find pretty neat:

dddd* mm/dd/yyyy

Watch what happens when you widen the column!



"kelemvor " wrote:

Is there some way I can have Excel 2k put the DAY that corresponds
to a
specific date? So if I type in 6/9/04 it would put in Wednesday
6/9/04?

Not sure if that's included anywhere.

Thanks.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson


--

Dave Peterson

I should have mentioned that Wraptext has to be enabled, too.

(also xl2002)

Earl Kiosterud wrote:

Dave,

I couldn't get the Alt-0010 to work. It drops to a second line in the
custom format box as you would expect (I have to arrow up and down -- it
only shows one line at a time in that box). But it just puts a square in
the cell where the 0010 code was in the format code. XL2002.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave Peterson" wrote in message
...
I really like to use the 4 digit year, too!

and one mo

dddd[alt-0010]mm/dd/yyyy

where [alt-0010] is not typed. Hit and hold the alt-key and type 0010
from the
numeric keypad.

It looks nice centered in the cell--but it doesn't behave very nicely with
autofitting rows or columns.

Looks kind of like this:

Sunday
06/13/2004




Earl Kiosterud wrote:

And try these.

dddd *- dd/mm/yy
dddd ** dd/mm/yy
dddd *. dd/mm/yy
dddd*.dd/mm/yy

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave Peterson" wrote in message
...
One more format that I find pretty neat:

dddd* mm/dd/yyyy

Watch what happens when you widen the column!



"kelemvor " wrote:

Is there some way I can have Excel 2k put the DAY that corresponds
to a
specific date? So if I type in 6/9/04 it would put in Wednesday
6/9/04?

Not sure if that's included anywhere.

Thanks.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Dave,

Thanks. This made me realize that even when you put a LF (Alt-Enter or
CHAR(10)) in text in a cell, wrap text must be on (it gets turned on
automatically). I dinna know that. Sounds as if they should have named it
"multiline," not "wrap text."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave Peterson" wrote in message
...
I should have mentioned that Wraptext has to be enabled, too.

(also xl2002)

Earl Kiosterud wrote:

Dave,

I couldn't get the Alt-0010 to work. It drops to a second line in the
custom format box as you would expect (I have to arrow up and down -- it
only shows one line at a time in that box). But it just puts a square
in
the cell where the 0010 code was in the format code. XL2002.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave Peterson" wrote in message
...
I really like to use the 4 digit year, too!

and one mo

dddd[alt-0010]mm/dd/yyyy

where [alt-0010] is not typed. Hit and hold the alt-key and type 0010
from the
numeric keypad.

It looks nice centered in the cell--but it doesn't behave very nicely
with
autofitting rows or columns.

Looks kind of like this:

Sunday
06/13/2004




Earl Kiosterud wrote:

And try these.

dddd *- dd/mm/yy
dddd ** dd/mm/yy
dddd *. dd/mm/yy
dddd*.dd/mm/yy

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave Peterson" wrote in message
...
One more format that I find pretty neat:

dddd* mm/dd/yyyy

Watch what happens when you widen the column!



"kelemvor " wrote:

Is there some way I can have Excel 2k put the DAY that
corresponds
to a
specific date? So if I type in 6/9/04 it would put in Wednesday
6/9/04?

Not sure if that's included anywhere.

Thanks.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Excel seems smart enough to notice when you do the alt-enter manually--but I've
never seen it do it if it's part of a formula.



Earl Kiosterud wrote:

Dave,

Thanks. This made me realize that even when you put a LF (Alt-Enter or
CHAR(10)) in text in a cell, wrap text must be on (it gets turned on
automatically). I dinna know that. Sounds as if they should have named it
"multiline," not "wrap text."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave Peterson" wrote in message
...
I should have mentioned that Wraptext has to be enabled, too.

(also xl2002)

Earl Kiosterud wrote:

Dave,

I couldn't get the Alt-0010 to work. It drops to a second line in the
custom format box as you would expect (I have to arrow up and down -- it
only shows one line at a time in that box). But it just puts a square
in
the cell where the 0010 code was in the format code. XL2002.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave Peterson" wrote in message
...
I really like to use the 4 digit year, too!

and one mo

dddd[alt-0010]mm/dd/yyyy

where [alt-0010] is not typed. Hit and hold the alt-key and type 0010
from the
numeric keypad.

It looks nice centered in the cell--but it doesn't behave very nicely
with
autofitting rows or columns.

Looks kind of like this:

Sunday
06/13/2004




Earl Kiosterud wrote:

And try these.

dddd *- dd/mm/yy
dddd ** dd/mm/yy
dddd *. dd/mm/yy
dddd*.dd/mm/yy

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave Peterson" wrote in message
...
One more format that I find pretty neat:

dddd* mm/dd/yyyy

Watch what happens when you widen the column!



"kelemvor " wrote:

Is there some way I can have Excel 2k put the DAY that
corresponds
to a
specific date? So if I type in 6/9/04 it would put in Wednesday
6/9/04?

Not sure if that's included anywhere.

Thanks.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson