I am generating some reports and i found that when the output figures is big, (say like in 7 digit), PDMS will change the result to a exponent value, for example 0.123456EX+07. This give me a problem when i transfer my data to excel as the excel cannot recognize it. What i been doing is by changing the EX to E in excel. But still, i think it would be better if i can get the value in number (in this case is 1234560) in stead of exponent value. So. is there any way we can change our output to number in stead of exponent value???
There's a customisation option in reports.
When you are creating a report, goto the column layout option, there you'll find setting for numerical display.
What type of object you are using in your macro for this value? Is this value set as string or real?
String can be changed to real by method: !real = !string.real()
It is actually the position of element, which is a string value. And i split it and change it to real like what u said . But when i output this real value, it becomes exponent value when the figure is large. (like in 7 digit). So, it would be good if i can set something to make sure the output always has 2 decimal.