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 - Exceladvisorr@gmail.com
Telegram - t.me/+UAVHfg7O...
14 окт 2024
