You are here: All Help Topics > Other Information > Cell Functions > MASK function

MASK Function

The MASK function takes a string and formats it according to a mask set up in Working Papers or Time. A mask is a layout for group or map numbers that may insert spaces in the numbers or give them a special alignment.

MASK("Group Number","string")

Where

Group Number is the group number or map indicator, M.

MASK("2","8.1")

Returns the string 8.1 as laid out in the mask for Group 2.

MASK("M","115.1")

Returns the string 115.001 as laid out in the mask for map numbers.

Related Topics