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.
Excel has many built-in formats that you can use: Currency, Accounting, Date, Time, Percentage, etc. If you cannot find the right format, you can create a custom number format. For example, you might have codes that consist of 5 numbers. Instead of typing 00041, simply type 41 and let Excel add the leading zeros. 1. Enter the value 41 into cell A1. 2. Select cell A1, right click, and then click Format Cells. 3. Select Custom. 4. Type the following number format code: 00000. 5. Click OK. Note: Excel gives you a life preview of how the number will be formatted (under Sample). Result: Note: cell A1 still contains the number 41. We only changed the appearance of this number, not the number itself.