Reformatting of Value

av686165

• April 04, 2020 00:00

• Answered

Follow

Could you please let me know how to formatting for below types of records,
2.44266E+21

When I am using Format cell functionality in MS excel , the below value has been transformed into 2442660018000190000000.

I want to achieve the same in CloverDX. Please assist.

• 

  vitd

  • April 08, 2020 08:47

  0

  Comment actions Permalink

  Hello,
  
  then double precision values are stored in number type variables in CTL2. This can be easily formatted by:
  
  

  
  number value = 2.44266E+21;
  string formatted = num2str(value, "#") ;
  printLog(info, formatted) ;
  

  
  
  Please note that the resulting value might differ between Excel and CloverDX because of the different rounding. In order to save the precise values, the decimal data type is rather recommended.

Please sign in to leave a comment.