Hi,
I get a strange problem when I convert a number in Excel to XML, using the Save as.. option.
When converting some numbers to XML, the number is set to a length of 18 digits long.
For example:
1. A number like 33234.4 will be converted to <Cell ss:Index="5"><Data ss:Type="Number">33234.400000000001</Data></Cell>
2. A number like 26450.8 will be converted to xml as <Cell ss:Index="5"><Data ss:Type="Number">26450.799999999999</Data></Cell>
But 126450.8 will be <Cell ss:Index="5"><Data ss:Type="Number">126450.8</Data></Cell>
Or A number like 33234.42 will be converted to <Cell ss:Index="5"><Data ss:Type="Number">33234.42</Data></Cell>
How can I solve this problem? Suggestions are welcome.
YT.
Bookmarks