Hi

Once you make the format general, then go to a spare cell somewhere, enter 1, copy, highlight all the data in column B, pastespecial, multiply, OK. This should convert all the data to numeric. Make sure you remove the 1.

HTH

rylo