New
#1
Excel 2007 Date Factor
I have a spreadsheet of inventory items and the dates are in various formats Europe , USA , and Eastern.
Example below. What I need to do is select all the dates and covert into one recognizable formula
Month (1) Day (1) Year (****). Let me know how to do this. Thanks!
7/12/00
28/12/0021/12/00
21/12/0026/12/00
28/12/0023/01/01
25/01/0104/01/01
11/01/011/2/20016/1/2001
27/01/018/11/00
27/01/01