• 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.

I have one number in crore how i convert in short number

Assuming the value "22cr 25 lakhs 66 thousnads 224" is in cell A3 and it is text, then try in [B3]
=(MID(A3,1,FIND("cr",A3)-1)&MID(A3,FIND("cr",A3)+3,3))/100

Note I'm not al all familiar with lakhs.
 
Can i get this in pivot table
Name salary year
Abc 16000. 2017
Abc 18000 2018
Abc 19000 2019

Not like this
Name salary year
Abc 2019. 19000
2018. 18000
2017. 16000
 
Back
Top