Cannot maintain the % formatting when exporting to Excel (HTML option)

2 posts, 0 answers
  1. Peter From LA
    Peter From LA avatar
    35 posts
    Member since:
    May 2005

    Posted 21 Aug 2015 Link to this post

    I have a grid which contains a column with DataFormatString="{0:0.00%}"...

     All looks great in the grid, but when I export to Excel I see the 1.00 instead of 100% and 0.25 instead of 25%.

    Is there a way to transfer the formatting to the Excel file?

  2. Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 26 Aug 2015 Link to this post

    Hello Peter,

    I am not sure which export format you are using but in case this is the default one then I would recommend you to examine the following help article for additional information about number formats.

    Regards,
    Kostadin
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top