Hi,

Cell Format as "000000"
Or in another column : =LEFT("000000"; 6-LEN(A1) ) & A1
Or =IF(LEN(A3)=6;"";
LEFT("000000"; 6-LEN(A3) ) & A3)
Regards
JY

"SHAWTY721" wrote in message
...
I am trying to figure out a way to check to see if the cells in a column
have
6 characters and if it doesn't is there a way I can have zeroes inserted
for
the cells that don't contain 6 characters in the designated column.