Convert scientific notation into decimal

Hi, I need to convert 4.00000000E-8 into a decimal value. This needs to be done because the XML output that results without this change is not accepted by the app to which I send this information. I've seen a function called formatDecimal, but not sure how to configure it. The values come as a bulk and may be in scientific format or in decimal format already, therefore the function should work to keep the decimal format for the ones already in that format and convert only the scientific format. If that is not possible, at least let me know how to change the scientific format into decimal. Much appreciate.   Many thanks and kind regards, Razvan
1 answers

Did you see this part of the documentation: