Add leading zeros to number based on character count

[pto160]

I am trying to figure out how to add leading zeros to a number. The end result always has to be 6 characters long. So 456 would be 000456 or 80 would be 000080.
The number could vary in length. I have Excel 365.

Book1
	A	B
1	Code	What I want
2	8500	008500
3	36141	036141
4	70	000070
5	478	000478
Sheet1

 

[GuzmanServices]

The formula for B2 should be:
=TEXT(A2,"000000")

 

[pto160]

Great. That works fantastic.