How to get complete dates with dd/mm/yyyy hh:mm:ss when exporting to excel?

[#1]

Hi,

I have a table box which have dates as below

23/09/2009 11:27:57

23/09/2009 11:26:07

28/10/2009 12:30:45

when I am sending information to excel it is loading only up to 23/09/2009 11:27

but I need seconds as well. can anyone please help me how to get seconds also when I am exporting to excel. I tried many ways but not working.

Thanks.

[amit_saini · Accepted solution]

Amelia,

See attachments.

Go to properties-->Number-->select Timestamp option.

Thanks,
AS

[qlikoqlik]

Hi Amelia

Please check the format under Number tab, if need set it to time stamp format

Thanks

Padma

[#4]

Thanks.