I changed the formula into value with the first codes below. This code, however, has some limitation. The value of the selected cells which starts with 0, for example, 0022111, will be turned into 22111 with this code. So I came up with the second one. What would you do if it were you?
Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks