when I load data to spreadsheet through add-in to the spreadsheet having
dates in the european format - dd/mm/yyyy and number format as *dd/mm/yyyy it
is displyed wrongly (i.e. my source date is 08/10/2008 as general/text and
the data displyed in Excel sheet cell having date format as mentioned above
is 10/08/2008)

All this works fine if I set the Datatype for column as text which I do not
want to do .