format census tract numbers

A

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.
 
J

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.
Click to expand...

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

Generalize to meet your need.
 
Top