I am importing data into excel from a Computer maintenance management system. The problem is the data that is imported is in a format excel doesn't recongnize. This is the result of a "year 2000 bug fix". The dates are in this format:
991023 : which is Oct. 23, 1999
1001023: which is Oct. 23, 2000
1011023: which is Oct. 23, 2001
1020403: which is Apr. 3, 2002
How can I make excel put this into a standard format such as 10/23/99, or Oct/23/01. Please help.
991023 : which is Oct. 23, 1999
1001023: which is Oct. 23, 2000
1011023: which is Oct. 23, 2001
1020403: which is Apr. 3, 2002
How can I make excel put this into a standard format such as 10/23/99, or Oct/23/01. Please help.