Results 1 to 4 of 4

Thread: S s m t w t f

  1. #1

    S s m t w t f



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    118
    Articles
    0
    The short answer is "No", you can't do it with format.

    One method using a formula is:

    Code:
    =LEFT(TEXT(A1,"ddd"))

  3. #3
    But as Tony said, TEXTing it means it is no longer a date!

  4. #4
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •