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.