help required to change format when converted from excel to xml.
=TEXT(A2,"0.0000%")
--
David Biddulph
"tdnithin" wrote in message
...
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
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" ssarent="s24"
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/
<Borders/
<Font x:Family="Swiss" ssize="7"/
<Interior ss:Color="#FFFFFF" ssattern="Solid"/
<NumberFormat ss:Format="0.0000000000%"/
</Style
Please help me to resolve this issue.
Looking forward for a quick response.
rgds
NithinJ
--
tdnithin
|