This question is locked. New answers and comments are not allowed.
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
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
1 Answer, 1 is accepted
0
Hi Tony,
Vlad
the Telerik team
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 >>