Select Data – Press Ctrl 1 – Format cell will open – Go to Custom – Delete General and type #,,,.00/" Lakh/"%% – Now click before the 1st percent sign and press on Ctrl J – Now press OK – Click /"Wrap Text/" to remove %%.
————————————
#,,,.00/" Lakh/"%% # (hashtag) ,(1 comma) , (2 comma) , (3 comma) . (End period) 0 (Number zero) 0 (Number zero) /" (Open quotation marks) LAKH (type LAKH) /" (Closed quotation marks) % (1st percent sign) % (2nd percent sign)
————-
I upload Excel related tips and shortcuts that can save your time when working on the Excel sheet. I also upload tutorials in English and Hindi to understand the formula with some basic examples.
Contact me :-
Email – [email protected]
Telegram – https://t.me/UAVHfg7OMBk5M2M1
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments