Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Listing day in 'ddd' format (2007)

    Hello All,
    I have a time/date grid on one of my spreadsheets. On one row I want to display the day in the three digit format, like Mon for Monday. Does anyone have an idea how to do this?

    Thanks in advance!
    Mark

  2. #2
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listing day in 'ddd' format (2007)

    Thanks so much! It works.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Listing day in 'ddd' format (2007)

    <P ID="edit" class=small>(Edited by Jezza on 16-Feb-08 22:12. Change format ooops)</P>Hi Mark

    Highlight the cells you want to format in this way.

    1) Click Format
    2) Click Cells
    On the Number Tab,
    3) Click Custom
    In the box below Type:

    4) Type DDD
    5) Press OK
    Jerry

Posting Permissions

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