S s m t w t f

Tony Jollans

New member
Joined
Mar 21, 2011
Messages
22
Reaction score
0
Points
0
Location
Norfolk, UK
Website
www.wordarticles.com
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, then :) I 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.
 
Back
Top