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

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

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?