1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2003 Date format

Discussion in 'Business Applications' started by Rainman50, Jan 13, 2006.

Thread Status:
Not open for further replies.
Advertisement
  1. Rainman50

    Rainman50 Thread Starter

    Joined:
    Feb 6, 2004
    Messages:
    70
    I have an existing Excel spreadsheet that contains the date format mm/dd/yyyy. I want to convert it to mm/dd/yy. Excel will not convert the current cells to the new format without re-entering the information. Can anyone help? Thanks in advance.
     
  2. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,782
    My excel does
     
  3. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Select the cell, press Ctrl + 1, Number (tab), select date and the date format you want. No changing of the cell values needed, only format.
     
  4. Rainman50

    Rainman50 Thread Starter

    Joined:
    Feb 6, 2004
    Messages:
    70
    I tried this, it does not change the current info. The information has to be re-entered. The cell is formatted, but the currnet date format is not edited.

    I want to change xx/xx/xxxx to xx/xx/xx.
     
  5. TonyJollans

    TonyJollans

    Joined:
    Jun 24, 2004
    Messages:
    114
    It sounds like your cells contain text and not 'proper' dates. If so ...

    Put zero in an unused cell somewhere - and Copy it.
    Select your dates and Paste Special > Add
    Now try and format them again.
     
  6. Rainman50

    Rainman50 Thread Starter

    Joined:
    Feb 6, 2004
    Messages:
    70
    Sorry, no go. Not sure what is going on with this doc. Thanks for your help!
     
  7. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,782
    Can you post it on here?
     
  8. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    I would assume that it is not an actual (Excel recognized) date then.
     
  9. Dreambringer

    Dreambringer

    Joined:
    Jan 19, 2005
    Messages:
    1,351
    You could try to copy the column, and paste special > Values, then formatt the cells.
     
  10. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    I'm not so sure about paste special values, but possibly Text to Columns, if it's a number issue.
     
  11. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,782
    rainman, how about posting the sheet on here so we can look at it?
     
  12. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/433832

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice