converting db need six digit w leading zeros,

[eStreet4ever]

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

 

[Brad]

=right("000000"&a1,6)

Assuming information is in cell a1

 

[Jacob Skaria]

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")