Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Mar 2001
    Location
    OK, USA
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dates (Excel 97)

    I am using windows ME and Excel 97. I have a column headed date and have the following problem. I enter the date as 6nov03 and it comes out as 06-Nov-03 which is OK, but a couple of times the date comes out as 05-Nov. What can I do to get the complete date of 05-Nov-03?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Dates (Excel 97)

    Set the number format for the column to the desired format. You can do this before you start entering dates, or afterwards.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dates (Excel 97)

    Gerald:

    I suspect that the cells that do not show the year are where you have not entered the year, i.e. only entered '6nov'.

    To ensure the display is as you want, regardless of whether you type in the year or not:

    Click on the column heading (to select the whole column)
    Select Format/Cells/Custom
    In the Type box type: dd-mmm-yy

    If you omit the year when entering the date, Excel will assume the current year.

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Dates (Excel 97)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> gbailey

    For a consistent format try and use the "d-mmm-yy", or "dd-mmm-yyyy", format across the column. The number of ds determine if you get 1-9 then 10-31 with one d, 01-09 and 10-31 with two ds, and then Mon-Sun or Sun-Sat with three ds, and with Four ds you get the name of the day spelled out. Same thing with the Ms for month.

    I tried it, and it did not give me any problems, and I want to point out to you, that Windows ME is not a stable version of Windows as others, so it will be a good idea to upgrade.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    Lounger
    Join Date
    Oct 2003
    Location
    Birmingham, England
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dates (Excel 97)

    << ....that Windows ME is not a stable version of Windows as others, so it will be a good idea to upgrade. >>
    Or downgrade?

Posting Permissions

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