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.
You may have at least three reasons to convert text-formatted numbers in Excel. 1  To make such functions as LOOKUP, VLOOKUP and MATCH work correctly. 2  To perform math operations like counting, summing, etc. 3  Apply a custom number format.ost of the time Excel would recognize numbers in such cases as text. If text-formatted numbers prevent from the further work with your data, you can convert them back to number format using the Excel VALUE function, the standard Format Numbers option, Paste Special window or Numbers Stored as Text error indicator.