format census tract numbers
 

How do I format census tract numbers into a six digit format, suitable for
concatenation? I need to add zeroes on to the beginning of some cells, but
not others.

How do I format census tract numbers into a six digit format, suitable
for concatenation? I need to add zeroes on to the beginning of some
cells, but not others.

If cell A1 holds a tract number, one way is to use:
=TEXT(A1,"000000")

Generalize to meet your need.