If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Adding the DAY to a Date field?
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 |
#3
|
|||
|
|||
Adding the DAY to a Date field?
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 |
#4
|
|||
|
|||
Adding the DAY to a Date field?
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 |
Thread Tools | |
Display Modes | |
|
|