Converting % data point to different format for notepad extract

[xceej]

Hi
I have a macro to extract data from excel to a very specific format in a notepad doc. Most of it is fine but struggling with best way to convert 1 data point.
It's a percentage in excel but the extract must always be 9 characters, eg below:

0.05228% = 000005228
0.52280% = 000052280
5.22800% = 000522800
52.2800% = 005228000

Does anyone have a simple way of doing this?

 

[PeteWright]

Book1
	A	B
1	0.05228%	000005228
2	0.52280%	000052280
3	5.22800%	000522800
4	52.28000%	005228000
Sheet2

Cell Formulas
Range	Formula
B1:B4	B1	= REPT("0",9-LEN(A1*10000000)) & A1*10000000

 

[xceej]

Book1
	A	B
1	0.05228%	000005228
2	0.52280%	000052280
3	5.22800%	000522800
4	52.28000%	005228000
Sheet2

Cell Formulas
Range	Formula
B1:B4	B1	= REPT("0",9-LEN(A1*10000000)) & A1*10000000

This is very helpful, thanks - much more efficient than the way I was going about it. Have converted it to a VBA function for my macro
Thanks for the help!