||Using the SQL Server 2000 Reporting Services|
|Subject:||2005 SQL Server Reporting Services - Excel export|
When we export an Excel file from 2005 Reporting Service tool, those datestamp fields cannot be exported directly into a specific format "dd/mm/yyyy" for further manipulation by the Excel users. We cannot find the way out and only tail-made to export as string field "dd/mm/yyyy" and then manually convert using Excel formula. Is there any direct way to export into the specified date format without intervention on the Excel worksheet? Please help.