Welcome to Golden Software Support

LIMIT NUMBER OF DIGITIS IN THE GRID RESULT

Comments

1 comment

  • Avatar
    Sabrina Pearson

    Hi avishai,

    After you grid the data and convert it to XYZ, you can open the data in the worksheet and remove some of the digits. To round the worksheet values, use this line:

    Wks.Transform3(RangeMin:=2, RangeMax:=7, Equation:="A=round(A,2)")

    This rounds column A to the second digit after the decimal for rows 2 through 7. Repeat for all other columns and then save the worksheet.

    Thanks!

    Sabrina

    0
    Comment actions Permalink

Please sign in to leave a comment.