In cases such as this, all you need to do is go in and retype one of the characters and I think Excel comes out of its coma and knows its a number. Alternatively, you can do a find/replace for some common character, perhaps a decimal or a dollar sign.