Gregg County Assessor's Office 101 East Methvin Street Longview TX 75601 41.7 miles from Bullard 903-236-8417. Wood County Assessor's Office 301 East Goode Street Quitman TX 75783 45.3 miles from Bullard 903-763-2261. Upshur County Assessor's Office 215 Titus Street Gilmer TX 75644 45.8 miles from Bullard 903-843-3088
Formatting Numbers with the Excel Text Function. The text function also allows you to format numbers. Excel provides three characters to allow you to format numbers as text. They are the zero character, the hash character and the question mark. Each of the characters has a different effect on the numbers being formatted.
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.