Results 1 to 6 of 6

Thread: Formating a date field
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2008
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formating a date field

    I have a date field that is formated with the year(YYYY)-month(MM)-day(dd) I would like the 2008-01-11 to be displayed Friday, January 11, 2008.

  2. #2
    Board Regular dave3009's Avatar
    Join Date
    Jun 2006
    Location
    Inverclyde, Scotland
    Posts
    6,996
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Formating a date field

    Hi citizenrain

    Welcome to the board

    Custom format ddd, mmmm, dd, yyyy ought to do you right

    HTH


    Dave
    Please state your version of Excel, I use Excel 2007 on Win 10.
    Back up all data and test VBA code on a COPY workbook, and please use [code][/code] tags.
    HTML Maker | HTML Maker - FAQ

  3. #3
    Legend VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Formating a date field

    Try a Custom format

    dddd, mmmm dd, yyyy

  4. #4
    New Member
    Join Date
    Jan 2008
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formating a date field

    neither of these work.

    The date is in a pivot table the data is coming from an oracle database.

  5. #5
    Legend VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Formating a date field

    Perhaps it is a 'text date'. Select the date(s), Data > Text to columns. Click Next twice to take you to the 3rd screen. Check Date and select YMD on the drop-down, then click Finish. That should convert it to a 'real' date and the custom formatting should work.

  6. #6
    New Member
    Join Date
    Jan 2008
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formating a date field

    I import the data from the database into a worksheet then query the data to make pivot tables. I have tried formating the imported data but nothing happens. My guess is that i have to somehow convert the data to something that excel understands.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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