Like 22cr 25 lakhs 66 thousnads 224 how i convert it like 22.25 lakhs
M Manbar New Member Jan 15, 2020 #1 Like 22cr 25 lakhs 66 thousnads 224 how i convert it like 22.25 lakhs
GraH - Guido Well-Known Member Jan 15, 2020 #2 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.
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.
M Manbar New Member Jan 15, 2020 #3 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
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
V vletm Excel Ninja Jan 15, 2020 #4 Manbar What would be a connection Your #3 reply with Your original thread I have one number in crore how i convert in short number ? You should reread Forum Rules: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/ and continue after that as it has written, please.
Manbar What would be a connection Your #3 reply with Your original thread I have one number in crore how i convert in short number ? You should reread Forum Rules: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/ and continue after that as it has written, please.