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/>



<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

Hi Nithin

I think you are using Workbook.SaveAs to save the file as XML. In that case you have little control of the format.

Excel takes the CEllFormat and applies the same in XML

1). If cell has percentage format it will be saved as a number and the format will be part of the style

2). Though you have 2.8525% on your Excel range, the actual data would be 2.8524999999999998E-2

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi Shasur,
 Thanks for your reply.
  Basically I am using Workbook.SaveAs to save the file as XML.But the problem also persists if I save the excelspreadsheet as xmlspreadsheet by using the option in the excelsheet(FILE -> SAVEAS
-> XMLSPREADSHEET ).I am totally baffled why the excel is behaving like this.I have also placed the style defined in the xml for that value.

Kindly give me some ideas on this...

Regards,
TD