- Select an empty cell
- Hit Ctrl-c to copy it
- Select the cells you are trying to fomat
- Do Edit...Paste Special...Operation...Add
Sometimes adding 0 to a cell (or multiplying it by 1) forces Excel to convert it to a number which can then be formatted.
I suggest you make a copy of your workbook before trying any of these suggestions in case things go terribly wrong.