Link to home
Start Free TrialLog in
Avatar of marvo2010
marvo2010

asked on

Setting Excel column Format in SSRS

I have a stored procedure that runs and generates report which is consumed in ssrs,

But when the reports gets exported in excel, the date column gets changed and the number columns gets into a format that I do not want,

How can set the column format of the date column to yyyy-mm-dd hh:mm:SS.sss when the report is exported into excel from SSRS.
Is there a way to do this

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Humpdy
Humpdy

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of marvo2010
marvo2010

ASKER

I have been on this for ages and having to run this report manually. I hope that this works out and that the date format persist when the report is exported to excel.

Thanks