I am running Excel 2007. I have attached a sample book. The cell (now E2) is the results of another formula [=LEFT(D2,3)], so it may be considered text.
I have a list of about 600 different policy numbers, and I am just looking at the first 3 digits of them.
Bookmarks