Date reformatting help

[ryuwrx]

Hello all,

It's been a while since I was last here, but I have a new question that I'm hoping the gurus can help me with. I'm working on an excel doc that has 25k lines of data. One of the columns has a date currently formatted to "mm/dd" and I need to get the format to show "mm/dd/yyyy". If I change the column formatting to the proper formatting, excel doesn't recognize that "mm/dd" is a proper date, it's only seeing it as "nn/nn". Is there a simple solution to adding in the four digit year and the slash mark, so that excel recognizes it as a proper date format? I'm not too concerned about what year it adds because I can use the find/replace to change the years since they are sequential. Any help is appreciated.

Ryan

 

[AlphaFrog]

If you have mm/dd in column A ...

• Select column A
• Select from the menu Data\ Text to Columns
  1. Select Delimited and next
  2. De-select all the checkboxes and then next
  3. Select "Date" in the Column data format
  4. Finish

Then you should be able to format column A with any date format you like.

 

[ryuwrx]

Exactly what I was looking for. Thanks Alpha.