Need Help with VBA - Formatting column contents to be 5 characters
I have a macro that I used regularly. However, need to update the macro to reformat column A.
Column A should be formatted to text and should always be five characters for the account number.
So if the account number is 14, add 000 infront to make it five characters. Test-Spreadsheet.xlsx