Try =LEFT(A1,3)
--
It is nice to be important, but it is more important to be nice


"JcR" wrote:

I want to enter 5 digit zipcode in cell a1, and want the first three
digits of that zipcode to appear in cell a2

thanks