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.
Best Answer: Assuming your info 123456 is in cell A1, entering the following formulas will split this as required: 1) =LEFT(A1,2) 2) =MID(A1,3,2) 3) =MID(A1,5,2) Although this converts numbers to text, Excel is still able to use these to perform simple calculations if required.