Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format for D / DD to be (e.g.) m mo
don't know if need to make as suggestion or question, but with trying to make
things fit in narrow columns / have less items to read for the same info... would think that MS could have made option available for day of week to show for 1 or 2 places, and maybe to be discerned between caps / lower case.. D for m (form monday) DD for mo is this available in some other form??? thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format for D / DD to be (e.g.) m mo
don't know if need to make as suggestion or question, but with trying to
make things fit in narrow columns / have less items to read for the same info... would think that MS could have made option available for day of week to show for 1 or 2 places, and maybe to be discerned between caps / lower case.. D for m (form monday) DD for mo is this available in some other form??? thanks First Letter: =LEFT(TEXT(<<YourDate,"ddd"),1) First Two Letters: =LEFT(TEXT(<<YourDate,"ddd"),2) Rick |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format for D / DD to be (e.g.) m mo
One or two d's (or D's) are used to represent numerical values as in
dates, eg d/mm/yyyy or dd/mm/yyyy. Three d's in a format are taken to represent a three-letter day (Mon, Tue, Wed etc), whereas four d's would represent the full day (Monday, Tuesday, Wednesday etc). There is no formatting trick that will give you M or Mo for Monday, but you could use something like this: =CHOOSE(WEEKDAY(A1),"Su","Mo","Tu","We","Th","Fr", "Sa") where there is a date in A1. Hope this helps. Pete On Sep 12, 12:46 am, nastech wrote: don't know if need to make as suggestion or question, but with trying to make things fit in narrow columns / have less items to read for the same info... would think that MS could have made option available for day of week to show for 1 or 2 places, and maybe to be discerned between caps / lower case.. D for m (form monday) DD for mo is this available in some other form??? thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format for D / DD to be (e.g.) m mo
You can nest formulas to obtain various formats.
Examples: =TEXT("10/9/2007","ddd") will return day of week as 3 character abbreviation. =LEFT(TEXT("10/9/2007","ddd"),1) returns first character of day of week. =LEFT(TEXT("10/9/2007","ddd"),2) returns first 2 characters of day of week. =LOWER(LEFT(TEXT("10/9/07","ddd"),1)) returns first day of week in lower case. Note that the dates in the above formulas can be a reference to a cell containing a date. =LOWER(LEFT(TEXT(A1,"ddd"),1)) where A1 contains a date. Regards, OssieMac "nastech" wrote: don't know if need to make as suggestion or question, but with trying to make things fit in narrow columns / have less items to read for the same info... would think that MS could have made option available for day of week to show for 1 or 2 places, and maybe to be discerned between caps / lower case.. D for m (form monday) DD for mo is this available in some other form??? thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format for D / DD to be (e.g.) m mo
ahhh.. sorry answers would 99% time been what need because I'm just average
user, and I did not give enough info, this one thing been running into often. know all the rest, look good answers; but where I see DD or D might already be covered by: dd or d for number day eg: 5 or 05 for 5th of month, I think that if the D or DD are just redundant then could use as suggested: (Custom Format) D = m for monday, or DD = mo like may have said, have large need for this formatting as an automatic Custom Format. - thanks much. - "nastech" wrote: don't know if need to make as suggestion or question, but with trying to make things fit in narrow columns / have less items to read for the same info... would think that MS could have made option available for day of week to show for 1 or 2 places, and maybe to be discerned between caps / lower case.. D for m (form monday) DD for mo is this available in some other form??? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert European Date format to American Format | Excel Discussion (Misc queries) | |||
Convert date from text format to date format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) |