I have a currency field and I need to convert it to:
zero-filled right justified field with no decimal point which has 10

Is there an excel function in Excel 2003 or Excel 2007 which does

I will be saving the file as a text file. I have an excel speadsheets
with amounts like 10.23 and 1234.56 which I need to convert to
0000001023 and 0000123456. Any ideas?