Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
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) |
#4
|
|||
|
|||
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) |
#5
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
Date format | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Date format collapses diagram | Excel Discussion (Misc queries) |