Need Macro to find number which prefixed 0

April 11, 2012 at 04:02:25
Specs: Windows XP, HP
Hi Team,

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

See More: Need Macro to find number which prefixed 0

Report •

April 11, 2012 at 05:46:34
If the cells really contain dates, how about formatting them not to show the zeros?

If you choose Format...Date, you'll see an option for 3/14/01.

That format will not show leading zeros.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question