Скачать или смотреть How to convert Number into Lakh - Excel Tricks & Tips

Convert any numbers into Lakh format simply making some modifications.

Select Data - Press Ctrl + 1 - Format cell will open up - Go to Custom - Delete General & Type #,,,.00" Lakh"%% - Now make a click before 1st percentage sign and Press Ctrl + J - Now press OK - Click "Wrap Text" to remove %%.

------------------------------------
#,,,.00" Lakh"%% = # (hashtag) ,(1 comma) , (2 comma) , (3 comma) . (Full stop) 0 (Number Zero) 0 (Number zero) " (Open inverted commas) LAKH (type LAKH) " (Close inverted commas) % (1st Percentage sign) % (2nd Percentage sign)
-------------


I upload Excel related tips & shortcuts which can save your time while working on the Excel sheet. I also upload tutorials in English & Hindi to understand the formula with some basic examples.

Contact Me :-
Email - [email protected]
Telegram - https://t.me/+UAVHfg7OMBk5M2M1

New Video :-

Custom Formatting in Excel -    • Custom Formatting in Excel  

Excel 2024 Shortcuts Revealed! -    • Excel 2024 Shortcuts Revealed!  

Excel New Update : Focus Cell -    • Excel New Update : Focus Cell