+ Reply to Thread
Results 1 to 3 of 3

One-Letter Abbreviation for Weekday

  1. #1
    Registered User
    Join Date
    01-27-2009
    Location
    Paducah, KY
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question One-Letter Abbreviation for Weekday

    Without creating a separate column, how can I format the weekday portion of a date like this (N, M, T, W, R, F, S, for Sunday through Saturday)? For example: R.1/1/09. I'd like to use the custom number format function.

  2. #2
    Forum Contributor
    Join Date
    10-11-2007
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    251

    Re: One-Letter Abbreviation for Weekday

    =choose(weekday(a1),"n","m","t","w","r","f","s")

  3. #3
    Registered User
    Join Date
    01-27-2009
    Location
    Paducah, KY
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: One-Letter Abbreviation for Weekday

    Thanks for the quick response. I was trying to avoid having to add an extra column for the "choose" command. I know excel number formatting "ddd" gives "Sun, Mon,…" and "mmmmm" gives "J, F, M, A, M, J, J,…" for the months. I was hoping Excel had some undocumented code (but known by some, of course) where I could create my own cell number format maybe by creating my own [$-####] code.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1