J
JethroUK
Is it possible to format a date as "M" for monday?
I don't want to use a formula (Weekday, etc)
I don't want to use a formula (Weekday, etc)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Yes, go to Format>Cell>Custom, and enter ddd in the box.
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
J
JethroUK
That formats as "Mon" which i have at the moment as per my heading - I need
to format as "M"
to format as "M"
M
Mangesh Yadav
A1 contains your date. Use:
=LEFT(TEXT(A1,"dddd"),1)
Mangesh
=LEFT(TEXT(A1,"dddd"),1)
Mangesh
M
Mangesh Yadav
Sorry, I though you only didn't want to use weekday (instead of any formulae
at all).
Mangesh
at all).
Mangesh