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.
Converting Text to Numbers. 1  In Excel 2003, on the Format menu, click Cells. 2  In Excel 2007 or later, click the arrow to the bottom right of the Font section on the ribbon to call up the Format Cells dialog box. 3  On the Number tab, click General under Category, and then click OK. Select the cell in which you typed 1, and then right click and choose Copy. 2  Select the cells with the values that you want to convert to numbers. 3  Right click and choose Paste Special. 4  Under Operation, click Multiply and then click OK.