Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Problem with date format

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

    Default

    I work with dates a lot and I wanted to be able to put in 22302 and have it show as 2/23/02, so I formatted it and it worked great. The next day I went in and did the same thing and after I formated it and typed in 22302 and hit enter it shows me 1/21/61, OK, I got my dashes but where in the world did those numbers come from, I really would love to be able to use this, what am I doing wrong. Please help.

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dates in Excel are *designed* to be entered with slashes or dashes. Period.

    You may have set some kind of cell format, but it won't be read as a date. You can certainly type just 2/2 and hit enter and it will read 2/2/2002 if you have formatted it to.
    ~Anne Troy

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
  •