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 TD
