Set cell format Version 1-9 Excel

Action context for working with an Excel document

Excel instance

Excel context

Yes

Column of the cell

Column index

Row of the cell

A mask to create a custom format. Rules for custom format masks:

1) Any custom text (kg, man, pc, etc.) or symbols (including spaces) must be enclosed in quotation marks.

2) You can specify several (up to 4) different format masks using semicolons. Then the first of the masks will be applied to the cell if the number in the cell is positive, the second if it is negative, the third if the cell content is zero, and the fourth if the cell contains text rather than a number. 

3) 0 (zero) - one mandatory placeholder (digit), i.e. this space in the format mask will be filled with a digit from the number that the user enters into the cell. If there is no number for this space, zero will be displayed. For example, if the mask 0000 is applied to the number 12, 0012 will be output, and if the mask 0.00 is applied to the number 1.3456, 1.35 will be output. 

4) # (grid) - one optional placeholder - roughly the same as zero, but if there is no number for the placeholder, nothing is outputted

5) (space) - used as a separator of groups of digits of three between thousands, millions, billions, etc.

6) [ ] - you can specify the font color in square brackets before the format mask. The following colors are allowed: black, white, red, blue, green, yellow, light blue

Action context for working with an Excel document

Excel instance

Excel context

Yes

Row of the cell

Format

Format mask

A mask to create a custom format. Rules for custom format masks:

1) Any custom text (kg, man, pc, etc.) or symbols (including spaces) must be enclosed in quotation marks.

2) You can specify several (up to 4) different format masks using semicolons. Then the first of the masks will be applied to the cell if the number in the cell is positive, the second if it is negative, the third if the cell content is zero, and the fourth if the cell contains text rather than a number. 

3) 0 (zero) - one mandatory placeholder (digit), i.e. this space in the format mask will be filled with a digit from the number that the user enters into the cell. If there is no number for this space, zero will be displayed. For example, if the mask 0000 is applied to the number 12, 0012 will be output, and if the mask 0.00 is applied to the number 1.3456, 1.35 will be output. 

4) # (grid) - one optional placeholder - roughly the same as zero, but if there is no number for the placeholder, nothing is outputted

5) (space) - used as a separator of groups of digits of three between thousands, millions, billions, etc.

6) [ ] - you can specify the font color in square brackets before the format mask. The following colors are allowed: black, white, red, blue, green, yellow, light blue

Action context for working with an Excel document

Excel instance

Excel context

Yes

Action context for working with an Excel document

Excel instance

Excel context

Yes