replacing dates
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: replacing dates

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

    Default

     
    I have a problem with a dataset in which I have 3 sets of dates that were apparently entered as text, instead of as dates and look like mm/dd/yy. When I formatted each column to be date mm/dd/yyyy, no change takes place. How do I change 12,000 dates to say mm/dd/2001 instead of mm/dd/01? I tried replace ??/??/01 with ??/??/2001 and that didn't work. Thanks in advance!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this.

    Select the range of dates, go to Data, Text to Columns and hit Finish.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    (Sorry, didn't see Juan's post.)

    try highlighting your column and using text to columns under the data menu.

    You will probably just be able to away other with just hitting finish when the wizard pops up.

    Otherwise, hit next, next again, select the date radio dial with MM/DD/YY.

    Another option would be to put 1 in cell, copy it, and paste special multiply over your column.

    Good luck

    On 2002-02-26 07:58, Christine wrote:
    I have a problem with a dataset in which I have 3 sets of dates that were apparently entered as text, instead of as dates and look like mm/dd/yy. When I formatted each column to be date mm/dd/yyyy, no change takes place. How do I change 12,000 dates to say mm/dd/2001 instead of mm/dd/01? I tried replace ??/??/01 with ??/??/2001 and that didn't work. Thanks in advance!
    [ This Message was edited by: IML on 2002-02-26 08:08 ]

    [ This Message was edited by: IML on 2002-02-26 08:09 ]

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

    Default

      
    Thank you Juan and IML!! It worked!!
    Christine

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
  •  

 

 
DMCA.com