Convert to text

[thedeadzeds]

Hi Guys,

How do I convert a column of numbers to text where the desired result always needs to be 6 digits. The desired result should have zero at the start depending on how many numbers there are. Number column will not exceed 5 digits

Number	Desired result
678	000678
647	000641
11421	011421
1161	001161

 

[shaowu459]

工作簿1
	A	B	C
1	Number	Desired result
2	678	000678
3	647	000647
4	11421	011421
5	1161	001161
6
Sheet1

Cell Formulas
Range	Formula
B2:B5	B2	=TEXT(A2,"000000")