Cell Formatting

[Jason W]

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?

 

[Mike H]

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

 

[Gord Dibben]

Data>Text to Columns>Fixed Width>Next>Column Data Format>Date>DMY or MDY and
Finish


Gord Dibben MS Excel MVP

 

[Jason W]

Mike to clarify I'm importing text data that is formatted MM/DD/YY. However,
if the month is not a double digit month it comes in with a space before the
month like
" 8/11/08" or " 8/01/08" I would like to throw some VBA code into the
import macro that will update the date to the M/D/YYYY format