Hey peeps, I'm having an issue with Excel's amazing auto-formatting. I'm entering 12-digit UPC codes consisting of all numbers into column D. When the codes are put in they are of course formatted awkwardly, but even when I change the format from "General" to "Numbers" and run my Macro, is either copies the value of the cell in the general formatting or pastes the value at the destination cell using general formatting.
Here is my code that works with no errors.
I tried using an Integer instead of a string and the CInt function as follows but with no joy; ran into errors.
Any help would be awesome!
Bookmarks