Export to excel formats cells [$-1010809]dd/mm/yyyy

[SQLWilts]

Has anyone seen the above?
I have a repot that I need to export to excel. The user then selects a range of cells and copies and pastes them into another spreadsheet.
Problem is that the date then appears as a number. This appears to be because reporting services exports the date date column, excel doesnt understand the "d" format, and applies the [$-1010809]dd/mm/yyyy format. Now I know that one can select the column and re-apply the format, but I dont want my users to have to do that. Is there any way to use a date format in reporting services that excel understands?
I am using SSRS 2005 and Excel 2002
thanks for looking

 

[xlbo]

Have a try with yyyy-mm-dd

AFAIK, that is a standard date format that should be recognised by just about anything

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question