This is a migrated thread and some comments may be shown as answers.

Date is rendering as a number in excel not a date

2 Answers 28 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Janus Pedersen
Top achievements
Rank 2
Janus Pedersen asked on 21 Aug 2009, 01:10 PM
Hi
I have a report with a date and when it is translated to a Excel the date is a number.

14-02-2008 07:31:00 will be 39492,3131944444
and
09-07-2008 12:30:00 will be 39638,5208333333
pls. help my here.

OS info:
Win XP
Telerik version : Q2 2009
.NET : 3.5
Lang. DK

Janus S. Andersen

 

2 Answers, 1 is accepted

Sort by
0
Accepted
Chavdar
Telerik team
answered on 21 Aug 2009, 03:24 PM
Hello Janus Sick Andersen,

You have to set the Format property of the Textbox item as well. Either put {0:d} or use the Format Builder to select one of the predefined date-time formats.

Sincerely yours,
Chavdar
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
Janus Pedersen
Top achievements
Rank 2
answered on 23 Sep 2009, 09:54 AM
Thanks it works fine
Tags
General Discussions
Asked by
Janus Pedersen
Top achievements
Rank 2
Answers by
Chavdar
Telerik team
Janus Pedersen
Top achievements
Rank 2
Share this question
or