The solutions to the 7 issue is available out here, however have you considered just using the INT formula in the cell/cells where you want the 1 or 2 or x etc?

=INT(A1/100) in any cell other than A1 will result in the number 1, assuming cell A1 holds any number from 100 to 199, etc.

Example: cell A1 has the number 257
if cell A2 has the formula =INT(A1/100)
the result in A2 will be the whole number 2