Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Oct 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 97 (Win95, Office 97)

    Can a column be formatted for dates of weekly appointments or contacts? Basically, I would like to find a less cumbersome way of typing in 6 months worth of weekly appointments down a column.

    Any help out there?

    Ken Prescott

  2. #2
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 (Win95, Office 97)

    Hi Ken

    Not understanding your question here, can you show what the cell entries need to look like? You can do various things with custom formats. (Ctrl+1 on a cell, or range of cells, select the Number tab, if none of the inbuilt date/time formats work for you, click Custom and create one of your own.)

    If you give some idea of what format you want, and what range of date/times you are looking to create, I'm sure I or others will help.

    Regards
    Peter

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 (Win95, Office 97)

    If you mean that you want to enter a list of dates for weekdays only then put in your first date, select the cell and right click and drag down the column, when you release the right mouse button you will get a shortcut menu from which you can chose "Fill Weekdays"

    edit
    (or at least you can in Excel 2000, Cant recall about 97)


    HTH

    Peter

  4. #4
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 (Win95, Office 97)

    Also works in Excel 97.

    Peter

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 (Win95, Office 97)

    Even works in Excel 5 and Excel 95!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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