locked
Export to excel and displaying total with $ sign RRS feed

  • Question

  • User-1129879462 posted

    I have a report having calculated columns that starts with $ sign.

    These columns when exported as excel does not displayed ... need to manually change the format

    Is there any workaround possible?!

    Thank you

    Regards
    Raj

    Friday, January 20, 2012 3:41 AM

Answers

  • User-933257319 posted

    are you exporting html as it is ?

    or are you using excel xml ?

    if you are using excel xml then you can acheive this using styles.

    this link will help u

    http://msdn.microsoft.com/en-us/library/aa140066%28v=office.10%29.aspx#odc_xmlss_ss:style

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, January 20, 2012 9:06 AM