Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am currently loading scientific values from excel using text(Field). But only for field value 3.50E+113 it's removing the 0 in the value and it's loading as 3.5E+113. Any workaround for this? I want the values as the same in excel.
8.94E+113 |
3.50E+113 |
6.29E+112 |
2.82E+112 |
8.76E+110 |
Hi,
try with this:
Evaluate(Num#(PurgeChar(Num(Subfield(A,'E+',1),'#.##0,00'),',') & Repeat('0',Subfield(A,'E+',2)-2),'#.##0'))
It's still not working. The 0 in the value is missing
File attached