Jason

Posting a date of 9/09/08 doesn't tell us which 9 is the month and which is
the day. When posting sample dates always use a day greater than 12 to make
it clear.

Also please clarify what is *9/9/2008 type

Mike

"Jason W" wrote:

I am importing a a date column where the date is formatted 9/09/08 (there is
a space before the first 9). Is there an If/Then macro I can use to update
the cell to the *9/9/2008 type?