birthdate
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: birthdate

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Judy
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am exporting from SASI student database and the birthdates export by yyyy/dd/mm and we need to format the birthdates into mm/dd/yy. We cannot change the birthdates. I have contacted SASI and they say it is an Excel problem.
    Any answers?
    Wawaloam

  2. #2
    Guest

    Default

    Is the date being imported as text? Try adding another column and using the datevalue() function to convert the string to a date, then format as you like.

  3. #3
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Or highlight the section, click (menu) Data-> text to columns. Click next. Uncheck all boxes, click next. Choose Data under the column data format, and select the MDY format. Click finish.

    Cheers, Nate

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
  •  

 

 
DMCA.com