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