Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change date format (Excel 2000)

    I need to remove the forward slash in the date format. IE. The date reads 01/05/04 so I need it to read 01052004. Also if the date is 01/05/98 I need it to read 01051998. Any suggestions?

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

    Re: Change date format (Excel 2000)

    Select the cells you want to format this way.
    Select Format | Cells...
    In the Number tab, click the Custom category.
    In the Type box, enter mmddyyyy
    Click OK.

    Note: you won't be able to enter a date as 01052004; Excel will interpret it as a number and translate that to a date not corresponding to 01/05/04. You will still have to enter a date as 01/05 or 01/05/04.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change date format (Excel 2000)

    Thank you.

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change date format (Excel 2000)

    Thank you, I wrote the macro to include those steps. How do I make a macro not column specific? When I wrote the last macro it records column D. However, I would like it generic so it would work on any of my date columns, not just column D.

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

    Re: Change date format (Excel 2000)

    Remove an instruction like
    Columns("D").Select
    and use something like
    Selection.EntireColumn.NumberFormat = "mmddyyyy"

  6. #6
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change date format (Excel 2000)

    Thank you. You just taught me something very basic, but very important.

Posting Permissions

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