Mohave Community College strives to meet the growing workforce needs of business and industry and to provide opportunities for small business development. MCC strives to provide high quality, affordable and accessible higher education to all who seek it
Returns or sets a Variant value that represents the format code for the object. expression .NumberFormat. expression A variable that represents a Range object. This property returns Null if all cells in the specified range don't have the same number format. The format code is the same string as the Format Codes option in the Format Cells dialog box. The Format function uses different format code strings than do the NumberFormat and NumberFormatLocal properties.
Select the cells that you want to format. On the Home tab, in the Number group, click the arrow, and then click More. In the Category list, click a category, and then click a built-in format that resembles the one that you want. In the Category list, click Custom. In the Type box, edit the number format codes to create the format that you want. To display both text and numbers in a cell, enclose the text characters in double quotation marks ( ) or precede the numbers with a backslash (\). Editing a built-in format does not remove the format.