Exporting to Excel, as a number, with formatting

2 posts, 0 answers
  1. tony
    tony avatar
    7 posts
    Member since:
    Oct 2010

    Posted 12 Dec 2011 Link to this post

    Hi,

    I noticed that when I have export to excelML with formatting, the number is stored as a String instead of a number.

    After some research, it turns out that I can hook up to the ElementExporting and store the value as a Decimal and Excel will read it as a number.

    This is all good, but is there a way to format the numbers in excel? Our string formatting has commas marking the thousands:

    String format: #,##0.00

    And we wish to have the values in excel to be in this format, and still be represented as numbers.

    Please let me know if this is possible,
    Thanks!
    Tony
  2. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 13 Dec 2011 Link to this post

    Hi Tony,

     You cannot have both format and the original value. Formatting a value is actually converting the value to string with specific format. 

    All the best,
    Vlad
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

Back to Top