Format the cell as General *and* re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"James" wrote in message ...
|I have imported a .txt file into my spreadsheet, however when I enter a
| formula it does not do anything. This is the formula I am entering
| =if(len(b1)=3,"0"&b1,b1)
|
| That is exactly how it shows up in the cell it does not calculate the
| formula. Is there a way to fix this without having to copy the data into a
| new worksheet?
|
| Thanks