In an application I have going I refer to a field
"Location", here are (samples):
4133
51053
617111

All are strict location numbers and no math
Will ever be performed using them..

I use Vlookup() formulas which use them
extensively. A recent "quick-programming-change"
I made recently caused me (to make it work) take
Several of these fields and enter the ' character
In front of to get it to work
'4133
'51053
'617111

I always stay clear of the Format such as Text as
I know it doesn't really make the cell value (4133) actually text.

For data entry is there some way I can enter 4133 alone
Without the leading ' and have it register to Excel as Text
So that it can be read in a Vlookup() without having to
Deal with the first ISERR() argument?

Thanks in advance,

Jim May