Export to Excel - Datetime Format

[Brot]

Hello @all,

if i display data in the grid all looks fine, e.g. a date value: 27.01.2015 - 08:49:42
I use this code for display and formatting: 

fields: {
...
date_time: { type: "date" }

columns: [
...
{ field: "date_time", title: "Date/Time", format: "{0: dd.MM.yyyy - HH:mm:ss}", width: "160px" }

But when i press "Export to Excel" the datetime value is display as: "27.01.2015". If i double click into a datetime cell then the value is display correctly as "27.01.2015  08:49:42". 
How can i change this that the hole datetime value will be displayed from the beginning?

Thx

[Alexander Popov]

Hi Brot,

You can set custom cell format as shown in following example: 

• Set Cell Format During Excel export

Regards,
Alexander Popov
Telerik