Formula does not work after import of .txt file

J

James

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
 
N

Niek Otten

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
 
Top