I have a very basic macro to convert all integers to stings within a used range:
This would work fine, BUT Excel doesn't recognize a NumberFormat change until you enter & exit each cell (only then do you see the cell warning "Number Stored as Text"). I know people use the Text To Columns function to workaround this 'quirk' but I really need a programmatic solution as I'm cleansing large data sets and integers can appear at random.
Any help would be very welcome. Thank you, in hopeful anticipation