Text function; Automatical conversion to scientific notation
I'm encountering a problem with converting my values to text with the TEXT() function.
When the value is 10,000,000 and I use the text() function, there is no problem. The text line item will show "10.000.000".
When the value is 10,000,000.15 (with 2 decimals <> 0), The text line item wil show '1.e7' instead of "10,000,000.15"
This causes problems with my export to other systems. Does anyone of you has encounterd the same problem /has found a workaround?