How can I remove a formatting code for a column of numbers. I am trying to compare two spreadsheets.
File 1 format 123-45-6789
File 2 format '123-45-6789
I need to remove the formatting code to do a vlookup. I already tried To remove the codes, click Options on the Tools menu, click the Transition tab, and then clear the Transition navigation keys check box. This did not work.
Any comments are appreciated.
Bookmarks