The short answer is "No", you can't do it with format.
One method using a formula is:
Code:=LEFT(TEXT(A1,"ddd"))
While I'm here can I ask a quick question?
I want to show dates as S S M T W T F - i.e. single characters for days of the week, but there doesn't seem to be a format that does this. I could do it with a TEXT formula, I suppose but then i won't have dates any more. I have managed it using CF but there must be a better way.
The short answer is "No", you can't do it with format.
One method using a formula is:
Code:=LEFT(TEXT(A1,"ddd"))
But as Tony said, TEXTing it means it is no longer a date!
Glad I wasn't being completely dumb, thenI don't do much in Excel these days and it's so easy to forget things. It wouldn't be hard to have a "DDDDD" format picture like the "MMMMM" one but if it ain't there, it ain't there.
CF seems so clumsy, but it does work so I'll stick with that.
Bookmarks