• 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


  • 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

GraH - Guido

Well-Known Member
Assuming the value "22cr 25 lakhs 66 thousnads 224" is in cell A3 and it is text, then try in [B3]

Note I'm not al all familiar with lakhs.


New Member
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