Cell value based on number of digits in another cell

Question

If Cell in column A contains 3 digits then cell in Column B should reflect text as "00" and if cell in column A has 2 digits then Cell in Column B should reflect text as "000"

Answer 1

Does this help?

=IF(LEN(A1)=3,"00","000")