The basic idea is using Excel number formatting guidelines as described in the Help page of the function. You can refer to the guideline in proper Website.
Or you can obtain number format programmatically as follows.
1. Prepare test Excel file.
2. In the Excel file, set format which you want to use in your application in the cell A1. In the following example, format is set as Accounting
3. Use the following program. In Template Excel File Path control, choose the Excel file you prepared. Then run the program.Note:
You can find Excel Get Range.vi
in the following path.
C:\Program Files (x86)\National Instruments\<LabVIEW version>\vi.lib\addons\_office\_exclsub.llb
4. You can obtain corresponding number format in Number Format indicator like below. Copy and paste it in number format input of Excel Set Cell Format.vi.