The Final Rule amends the definition of spouse so that eligible employees in legal same-sex marriages will be able to take FMLA leave to care for their spouse or family member, regardless of where they live. More information is available at the Wage and Hour Divisionâs FMLA Final Rule Website.
Apply a custom number format. Select the cell or range of cells that you want to format. On the Home tab, under Number, on the Number Format pop-up menu, click Custom. In the Format Cells dialog box, under Category, click Custom. At the bottom of the Type list, select the built-in format that you just created.
Cell Formats. Select the cells containing the number you wish to convert. Click the Number Format drop-down menu in the Home tab's Number group and then select Text..You can also right-click any selected cell, choose Format Cells and then select Text from the Category list.se the following format and replace the cell reference to that of the number you wish to convert: =Text(A1,0000.00). The part in quotes describes the format. In this example, the formula instructs Excel to format the number in A1 as text with four digits to the left of the decimal point and two digits after it.