I receive a text file which has a column containing data such as
"2010/04". this is not a date and represents the 4th period in the
fiscal year 2010 (which in calendar terms in Nov 2009). Excel 2007
after importing through the wizard automatically changes data in this
column to Apr-10. if i click on teh cell i see 2010-04-01 (my
regional date setting is yyyy-mm-dd). thus far i use the text import
wizard and instruct Excel to treat this column as text in order to get
2010/04.

However my colleague (same laptop, same software versions, Win-XP
operating system) does not have to go through above process to get
2010/04. The only difference we can determine is that his Regional
Date settings are mm/dd/yy against my yyyy-mm-dd.

Is it possible for me to keep my regional date settings of yyyy-mm-dd
and avoid the 4 extra key strokes needed to import this data??

Appreciate any response
Darryl