Format date as 'ddd' = "Mon"
 

Is it possible to format a date as "M" for monday?

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

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)

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)

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)

Sorry, I though you only didn't want to use weekday (instead of any formulae
at all).

Mangesh



"Mangesh Yadav" wrote in message
...
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)