basically im exporting some data to excel using XSLT.
i want to know how to write mso-number-format to EURO. in $ if the amount is 1997.2225 then i have written its as 1,997.2225 (i used this mso <TD class="xlRow" align="right"
style="mso-number-format:\#\,\#\#0\.00"> ) but, in Euro they use comma as a decimal seperator so, i want to write the data as 1.997,2225 how do i write this using mso-number-format?
Member
282 Points
1309 Posts
mso format in XSLT
Jul 15, 2013 11:47 PM|winseealn@hotmail.com|LINK
hi,
basically im exporting some data to excel using XSLT.
i want to know how to write mso-number-format to EURO. in $ if the amount is 1997.2225 then i have written its as 1,997.2225 (i used this mso <TD class="xlRow" align="right" style="mso-number-format:\#\,\#\#0\.00"> ) but, in Euro they use comma as a decimal seperator so, i want to write the data as 1.997,2225 how do i write this using mso-number-format?
experts please advice
Member
20 Points
8 Posts
Re: mso format in XSLT
Jul 17, 2013 02:40 AM|svensong7|LINK
Hi,
Please refer the similar thread
http://stackoverflow.com/questions/354476/html-to-excel-how-can-tell-excel-to-treat-columns-as-numbers
http://www.agoric.com/sources/software/htmltoExcel
Hope it can help you
Member
282 Points
1309 Posts
Re: mso format in XSLT
Jul 18, 2013 06:41 AM|winseealn@hotmail.com|LINK
i chnage my machine langauge to any one europe country. then open the same excel file now everything got worked.