|
/P# |
Meaning |
Extra Parameters: /1{Parameter1} … /n{Nth Parameter} |
|
108 |
Change the numerical formatting applied to specific cell(s) (e.g. General, Currency, etc.) |
/1 = sSheetStart (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{sSheetStart} Name of the sheet to alter. Required.
/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 |
Examples: