Formula does not work after import of .txt file

  • Thread starter Thread starter James
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
"What-if" formula for either a manual entry and automated entry 3
Concantenate which keeps bold of some parts. 5
Formula??? 3
Validation 4
Copying concatenate not returning correct cell information 6
Formula 4
Data Validation - Preventing Delete from Delete Key 2

Back
Top