Zero Pad
When displaying information like numeric product codes or batch IDs, it may be required to zero pad these values so that each is a consistent length. If the values are delivered as numbers, this function can zero pad them to a consistent length.
This function zero pads the value from every cell in the Apply To range, writing the zero-padded value to the corresponding cell based on the Placement. To overwrite the original value with the zero-padded value, set the Placement cell to the top left corner of the Apply To range.
Settings | |
|---|---|
Padding | This determines the maximum number of characters each value in the Apply To range is padded. |
Example
The part number fabricated by a machine must always be 12 characters in length with 0’s padding any part number less than 12 characters to be consistent. The report shows all the part numbers generated over the day with the part number itself starting in cell $C$4. To zero pad these values in place:
Apply To | |
|---|---|
Cell | $C$4 |
Direction | Down |
End | All cells are empty |
Placement | |
|---|---|
Cell | $C$4 |
Type | Direct |
Setting | Value |
|---|---|
Padding | 12 |