Results 1 to 3 of 3

Thread: Dates that aren't really dates, they're text

  1. #1

    Angry Dates that aren't really dates, they're text



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

    Hi,

    I have a spreadsheet that was created by our EtQ system, I'm not sure what rev of Excel it is. There is a columns labled "date", but the cell contents are text. Example "Apr 1, 2007". No matter how many times I try to format the cells to be dates, they will not change. Thus, I cannot sort by oldest to newest, I can only sort A-Z. Not helpful. Any thoughts of how I can correct this?

    Thanks!
    spreadsheet attached
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Select the column, go to Data|Text to Columns. Click Next twice, skipping to 3rd dialogue window. Select Date from the Column Data Format area, then click Finish. It should convert to real dates which you can format as desired.


  3. #3
    That did it!!! Thank you SO MUCH!!!

Posting Permissions

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