change the column value type in excel file 2000
<p>i have an excel file which is in excel 2000. it has around  25 columns,in the column18 the column name is "MONTH" here its data type is date time, the value is  displayed as (1/5/2009).
in a format(dd/mm/yyyy).</p>

<p>now i need to change its datatype to string and  display  the data as in this  format(01-05-2010)</p>

<p>hope my Question is clear.</p>

<p>can  any one  tell me  how  can i  change teh data type and  change the way we display  the data.
any  help  would be great how  to  go ahead.</p>

<p>Thanks
prince </p>
