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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks