Having a issue.

When i export from a SharePoint Portal, the dates are in 2 formats.

Start Date
12/03/2009
1/13/2010
02/12/2010
02/08/2010
8/16/2005
11/17/2009
10/13/2009
09/04/2010
06/03/2009
5/29/2009

Notice the second, this type doesnt want to change notice the 1 as month, the first and the third are the same, with 02 as month.

I have tried many formats in Formatting, but i cannot get them to match.

One resolution is in 2003 (personal laptop) i can select and copy all, then paste values only into a new workbook, this works. But if i do the same in 2007, only the 1 and 2 types paste as a number (the amount of days from 1/1/1900, or what ever that date is) and the 2 date type remains the same.

Any Suggestions.


Robert Woodlock
www.avaintcon.com