Last post Jan 20, 2012 09:06 AM by shirsath.sagar@gmail.com
Participant
1042 Points
658 Posts
Jan 20, 2012 03:41 AM|krisrajz|LINK
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
822 Points
277 Posts
Jan 20, 2012 09:06 AM|shirsath.sagar@gmail.com|LINK
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
Participant
1042 Points
658 Posts
Export to excel and displaying total with $ sign
Jan 20, 2012 03:41 AM|krisrajz|LINK
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
Raj
Remember to click Mark as Answer on the post that helps to others.
Participant
822 Points
277 Posts
Re: Export to excel and displaying total with $ sign
Jan 20, 2012 09:06 AM|shirsath.sagar@gmail.com|LINK
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