I have the above data which gets dumped from a website by one of our users. However, due to formatting issues, the macro setup I designed for her is not working. I've pin pointed one of the format issues to be above.
Card # are:
- Always 5 digits (including leading zeros)
I told her to use text version, such that she is putting '00023 in everywhere (eg) but the dumped data sometimes has this wierd stuff as above (no leading zeros and the format being in 'General' instead of text)
This is being an issue throughout the workbook. Is there a prebuilt function in VBA to change all above to text format and format it to 5 digits (fill in leading zeros)?
Any start-up help is appreciated and I can continue!
I want to design a button on top which would feed all values on the specific row to this function and paste it back as text.