Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help required to change format when converted from excel to xml.
Hi Guys,
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:Parent="s24" <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/ <Borders/ <Font x:Family="Swiss" ss:Size="7"/ <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/ <NumberFormat ss:Format="0.0000000000%"/ </Style Please help me..... Looking forward for a quick response. rgds TD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help required to change format when converted from excel to xml. | Excel Discussion (Misc queries) | |||
when loading csv file to Excel, cells get converted to date format | Excel Discussion (Misc queries) | |||
EXCEL, Figures if they can be converted into tiff or EPS format | Charts and Charting in Excel | |||
2/29 gets converted to 2/1 in excel. how do i change this? | Excel Discussion (Misc queries) |