=right("000000"&a1,6)

Assuming information is in cell a1

--
Wag more, bark less


"eStreet4ever" wrote:

I need to have a six digit value for an ID field. Old db has values ranging
from one to four characters and need to front fill with zeros