converting db need six digit w leading zeros,
 

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

converting db need six digit w leading zeros,
 

=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

converting db need six digit w leading zeros,
 

If this is just for display purpose then custom format the cells to 000000

The below will return the value as text and not numeric...
=TEXT(A1,"000000")

--
Jacob (MVP - Excel)


"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