If you are trying to convert the numbers in Column A to something like 010 and 01.0, I have done it after so many attempts.
Please click on this completed file:http://wikisend.com/download/473206/srgcd_done.xlsx
For Coolumn B, I just made a direct copy from Col A. That is, in B2, I made =A2 formula and copying the formulas all the way down. Regarding the padding of initial zeros, you just need to go to select B2 which contains 10, then click on the small down arrow in the Number group in the Home menu. In the left panel named Category, click on Custom then click on the 3 zeros. That will make your cell value fit into 3 digits MINIMUM and pad zeros for 2-digit entries. After doing that and if B2 now shows 010, drag the cell/fill handle to copy the format to the rest of the cells in Column B. Here is my screen shot:
Now regarding the decimals, here is the trick. In Column C, you just need to copy or reference the value B and divide it by 10 so that it will move the decimal one digit to the left. So in C2, enter =B2/10.
Now, copy the formulas all the way down column C. For columns with 2 digits, the initial zeros are removed. So you need to select C2 thenclick the small down arrow in the Numbner group. Click Custom in the Category then select the option 00.0. That will pad zero for 2digit cell values. Here is my screen shot:Please be sure to rate my answer with 3 or more stars/faces if this helped.
Keep me posted with your results so that I can help you further. If you have further question, please reply to me so that I can help you further.