Highlighted
Absent Member.
Absent Member.
243 views

[archive] Numbers in Excel

[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 ?
0 Likes
1 Reply
Highlighted
Absent Member.
Absent Member.

RE: [archive] Numbers in Excel

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').
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.