Skip to main content

[archive] Numbers in Excel

  • November 11, 2005
  • 1 reply
  • 0 views
D

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

    1 reply

    D

    [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').

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement