getting rid of the first 3 characters of a number

[Jerhansen277]

I'm sure this can be done but I can't remember the function

I have a column of check numbers. stored as 100XXXXX where X = the actual check number. I want to create a new column which gets rid of the 100, leaving the check number.

thank you

[NBVC]

If the check number is constant in length, then use =Right(A1,5) where A1 is the cell housing the data and 5 is the number of characters of the check number.

If not constant, then =MID(A1,3,255)

[Jerhansen277]

thanks! again!