I have to update data in an application. And the application accepts only 2000 characters to update. So I need to compress the data. I can’t reduce text field but I can reduce date field.
04/10/2012 to 4/10/12
12/04/2011 to 12/4/11
I need macro to find and highlights which are the data can be modified or which number have prefixed with 0.
Please help me to solve this issue.
Thanks in advance