format census tract numbers

[a_rust]

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.

 

[Jay]

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.