Formatting cells to have leading and ending zeros

We are working on importing a large budget with thousands and thousands of numbers and we have a specific format we need to follow in order for the import to work properly.
Our managers keyed all the budgets into excel spreadsheets. We have a few areas where we are having problems with account codes, sub account codes, and dollars.
Here is why?
Account 0120.0110 will import as 120.011 and we can't do that. The notes say you cannot just format the cells as 4 digits, you have to key them that way.
The dollar amount of 120.50 would come across as 120.5 and we need the zero on the end.
Is there anything formula that would fix this issue, rather than re-keying MANY, MANY numbers?
Thanks so much for any help you can offer me!

Perhaps format as number with two decimals for dollar amounts and format as 0000.0000 for account numbers

In a separate column use these

For account numbers use
=TEXT(A1,"0000.0000")

For dollar amounts
=TEXT(A1,"#.00")

Copy this column and paste special values onto the original column. Does that help?