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

Export to Excel and decimal Formatting

2 Answers 674 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Mike
Top achievements
Rank 1
Mike asked on 10 Feb 2010, 05:58 PM

I am exporting some decimals to excel and the formatting is dropping of two numbers.

Displays: 0.0051
Exports:  0.00 

I have tried the following below to no avail, your help would be greatly appreciated.  

 

 

DataFormatString=" {0}"     which gives me "?0.0051"  
 
DataFormatString="{0:f5}"           still 0.0051  
 

 

 

2 Answers, 1 is accepted

Sort by
0
Accepted
Daniel
Telerik team
answered on 10 Feb 2010, 06:49 PM
Hello Mike,

Please examine the following help topic and let me know if you need more information.
Word/Excel export (HTML-based) ( "Number formats / Formulas" and "ExcelExportCellFormatting event")

Regards,
Daniel
the Telerik team

Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.
0
Mike
Top achievements
Rank 1
answered on 10 Feb 2010, 07:35 PM
Thank You!
Tags
Grid
Asked by
Mike
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Mike
Top achievements
Rank 1
Share this question
or