Need to Drop Decimal but keep ending zeros

[tcnt9176]

Here's my problem. I need a formula to take the decimals out of a column but keep ending zeros. I have tried find/replace & several formulas but nothing seems to be working. Here is an example of the numbers in the column and the end result I need. Thanks!!!

9.66 966
0.50 050
13.09 1309
309.98 30998

 

[Peter_SSs]

Could you have done the whole lot in one go with this?

Excel Workbook
	A	B
1	9.66	0000000966
2	0.50	0000000050
3	13.09	0000001309
4	309.98	0000030998
Remove Decimal

 

[tcnt9176]

yep. that's why you guys are the experts!!! Too bad I had already worked on it manually That makes me feel so smart