Skip to main content

[Migrated content. Thread originally posted on 10 November 2005]

I want to change the property of a column to a Number (no currency) with 2 or more values after the decimal point.

How to accomplish this via Acucobol ?

[Migrated content. Thread originally posted on 10 November 2005]

I want to change the property of a column to a Number (no currency) with 2 or more values after the decimal point.

How to accomplish this via Acucobol ?
I use something like this in my codings:


       01  excel-objects.
           03  xls-app       handle of application of excel.
           03  xls-book      handle of workbook    of excel.
           03  xls-sheets    handle of worksheets  of excel.
           03  xls-sheet     handle of worksheet   of excel.
           03  xls-range     handle of range       of excel.


           inquire xls-sheet @CELLS::@RANGE("A1", "A1") xls-range.
           modify  xls-range @SELECT().
           modify  xls-range
                   @ENTIRECOLUMN::@NUMBERFORMAT('####0"."00').