To generate report with output in numbers in stead of exponent

 
Parents
  • Hi all,

    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???
Reply
  • Hi all,

    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???
Children