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.
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.