In column A I have 4 digit numbers such as 0801, 1225, etc. These all have green smart tags that I want to get rid of.
I am trying Columns(1) = format(Columns(1),"####") but it's not working.
Basically, set the values of column(1) to the values of column(1) which will clear the smart tags. But that truncate any leading zeros. So then I want to apply a number format so that everything in column(1) has 4 digits.
Any ideas?
Bookmarks