i have a cell with the following info in it:
when i do a search and replace of "-" to make it show as 01101, however excel makes it a number and it formats it this way: 1101.Please Login or Register to view this content.
how can i strip the code of the dash but preserve the leading zero? looking for a vba solution.
thoughts anyone?
Bookmarks