Hi Guys,
I am Using Microsoft office Excel 2003.
I am saving an excel file as xmlspreadsheet.
When I do this the values in column L of the excel spreadsheet is displayed in the xml spreadsheet in exponential form.
eg: 2.8525% in excel sheet is displayed in xml as
I am Using Microsoft office Excel 2003.
I am saving an excel file as xmlspreadsheet.
When I do this the values in column L of the excel spreadsheet is displayed in the xml spreadsheet in exponential form.
eg: 2.8525% in excel sheet is displayed in xml as
2.8524999999999998E-2
Could anyone please assist me in rectifying this: I need the value in the xml to be displaying in %age form.
e.g: 2.8524999999999998E-2 in xml should actually be displayed as 2.8525%.
style defined for this particular value in the xml as below.
<Style ss:ID="s109" ss
e.g: 2.8524999999999998E-2 in xml should actually be displayed as 2.8525%.
style defined for this particular value in the xml as below.
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<Borders/>
<Font x:Family="Swiss" ss
<Interior ss:Color="#FFFFFF" ss
<NumberFormat ss:Format="0.0000000000%"/>
</Style>
Please help me to resolve this issue.
Looking forward for a quick response.
rgds
NithinJ