A1 contains your date. Use:

=LEFT(TEXT(A1,"dddd"),1)


Mangesh




"JethroUK" wrote in message
...
That formats as "Mon" which i have at the moment as per my heading - I
need
to format as "M"


"Bob Phillips" wrote in message
...
Yes, go to FormatCellCustom, and enter ddd in the box.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JethroUK" wrote in message
...
Is it possible to format a date as "M" for monday?

I don't want to use a formula (Weekday, etc)