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.

Date Format in Excel

Discussion in 'Business Applications' started by cb13h, Jan 3, 2006.

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

    cb13h Thread Starter

    Joined:
    Oct 7, 2002
    Messages:
    64
    What format do I use when I type 010106 and want it to appear as 01/01/06?
    Thanks.
     
  2. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Hi there,

    That will probably show up as just a number and wont' be interpreted as a date. The format you want to use is:

    dd/mm/yy

    To apply, goto Format | Cells (or Ctrl + 1) | Number (tab), choose the format in the Date list or apply your own custom format with the format supplied above.

    HTH
     
  3. cb13h

    cb13h Thread Starter

    Joined:
    Oct 7, 2002
    Messages:
    64
    Thank you. You are right. The number wasn't recognized as a date. I guess it can't be done without typing the "/".
     
  4. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    You can use the - sign if you want, but you need something in there.

    Now this can be done, without adding any additional characters, with VBA if you like. But it would seem such a larger undertaking than just typing in a couple extra characters on entry.
     
  5. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    You guess correct. However, if you apply Zack's custom format suggestion in advance, you can then get away with typing:

    1/1

    for 01/01/06, which is much quicker.
     
  6. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    sorry I was giving an Access answer.
     
  7. 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/430689

  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