• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formulas/Functions not working on downloaded file

Bhawani

Member
Hi All,

I was going through with the post on below :

http://forum.chandoo.org/threads/need-a-formula-urgent.21653/

but functions/formulas are not working on it even calculations are maual.
 
If I copy =""&LEFT(D2,3)
to F2 it returns -C0 as it should

What isn't working ?
What are you doing ?
What version of Excel are you using ?
 
Hi Bhawani ,

Did you check the post by another member which suggested that the cell formats be changed to General or Number , after which you should enter the formula ?

Narayan
 
Hi Both Ninja,

Thanks for you kind revert,

@Hui After opening the file function were not working but after going wtih Text to column wizard it started working.

@Narayan yes i read that post also but unable to understand so was practicing with your function & facing problem then i asked question.
also narayan what rocker is trying to explain there or i should ask this on same thread.


Regards,
 
Back
Top