P108 Change Cell Number Formatting (command line example list)

Example:

Command Line Example 1: Apply 'Currency' formatting to a Range of Cells

 

 

P108 Command Line Reference:

/P#

Meaning

Extra Parameters

108

Change the numerical formatting applied to specific cell(s) (e.g. General, Currency, etc.)

/1 = sSheets - worksheet(s) to be modified (by name or number)

/2 = sRange (by number)

/3 = sNewFormat (by name)

/4 = lNewFormat (by number)

This special process can change the numerical formatting applied to specific cells containing numerical data.

Special Parameters Described in Detail

/1{sSheets} Required. Name of the sheet(s) to modify.

    Sheets can specified by name or number.  

              You may specify ranges by index:  i.e. "2-4,10" or "*" for all.

              You may specify by name: i.e. "Sheet4","Sheet6","Accounting"

/2{sRange} Range of cells being reformatted (i.e. "A1:B4, J10"). Required.

/3{sNewFormat} String version of the format being applied. Required.

/4{lNewFormat} Numerical indicator of the format being applied. Required.

 

Following is a complete listing of the /3 and /4 switches for each format type:

Format

/3 Switch (sNewFormat)

/4 Switch (lNewFormat)

Text

@

0

General

GENERAL

1

Number

#,##0.00

2

Currency

$#,##0.00

3

Accounting

($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

4

Date

m/d/yyyy

5

Time

[$-409]h:mm:ss AM/PM;@

6

Percentage

0.00%

7

Fraction

# ???/???

8

Scientific

0.00E+00

9