Numbers stored in .XML file

SAPconsultant2095   PS....

You wrote:  ``I'm having a problem with numbers while trying to upload my .XML files to another programs``

Explain the problem that you are having in "other programs".

What are the other "programs"?  Are they actually a different application?  Or do you mean "other Excel workbooks"?

Is the problem that 99999.998999999996 is input as 99999.9989999999, truncating instead of rounding after 15 significant digits, as Excel does with text input?

If so, you might need to work around the problem one way or another.

But it is difficult to advise you without more details; at least the answer to my questions.

-----

You wrote:  ``If I edit file (in notepad) and remove additional digits it looks alright, but when i'm trying to save a file with new numbers (99999,999) it goes back to previous number (99999.998999999996)``

That description does not make sense to me.

If you edit the XML file using Notepad, then save as an XML file, I assure you that the saved XML file contains your edits.  Notepad does not do any conversion of the text.  Confirm by re-opening the re-saved XML file in Notepad.

I suspect you are omitting some steps.

Perhaps you open the XML file in Excel, then re-save as XML.  In that case, of course, Excel rewrites the XML contents according to its own rules, as I explained them previously.

But again, we cannot advise you without more (and accurate) details.