I have a group of census tract numbers that I need to normalize in order to analyze.
The general format of a census tract number is ####.## but not every tract has six digits. I will need to remove the decimals, and add leading and trailing zeroes to get each of the numbers to be in the form of ######
For example, census tract 141.29 needs to become 014129, and tract 6 will become 000600.
Any help would be much appreciated as I am new to excel
The general format of a census tract number is ####.## but not every tract has six digits. I will need to remove the decimals, and add leading and trailing zeroes to get each of the numbers to be in the form of ######
For example, census tract 141.29 needs to become 014129, and tract 6 will become 000600.
Any help would be much appreciated as I am new to excel