I have two columns (A & B) in a CSV file. They have numbers ranging from 1 to 3000 with repeats. I need all values to be at LEAST 4 characters long (i.e. 4 = 0004), but anything larger than 4 is okay (just 4 or less needs to be adjusted).
What I can't do: Format the columns and make them Custom 0000
I need these values to be inserted back into SQL. Custom 0000 still leaves the value as 4 (using the example above).
I thought doing custom 0000 and then running my macro would work, but it didn't.
Macro:
Please Login or Register to view this content.
Bookmarks