Comma Separator in Excel: Million to Lakh/Crore Conversion
A technical way to show number formatting in Excel using Lakh / Crore Comma Separator. - No Language or Region change required. - Can handle both Positive and Negative values. - Usable in Bangladeshi Taka (BDT) and Indian Rupee (INR) Formula used for it: Positive Number: [Greater Than Symbol 9999999]##\,##\,##\,##0.00;[Greater Than Symbol[99999]##\,##\,##0.00;##,##0.00 Negative Number: [Less Than Symbol-9999999]-##\,##\,##\,##0.00;[Less Than Symbol-99999]-##\,##\,##0.00;##,##0.00 NB: Youtube does not allow to use greater than or Less than symbol here. Put those symbol instead of writing Greater Than Symbol or Less Than Symbol in the formula.
A technical way to show number formatting in Excel using Lakh / Crore Comma Separator. - No Language or Region change required. - Can handle both Positive and Negative values. - Usable in Bangladeshi Taka (BDT) and Indian Rupee (INR) Formula used for it: Positive Number: [Greater Than Symbol 9999999]##\,##\,##\,##0.00;[Greater Than Symbol[99999]##\,##\,##0.00;##,##0.00 Negative Number: [Less Than Symbol-9999999]-##\,##\,##\,##0.00;[Less Than Symbol-99999]-##\,##\,##0.00;##,##0.00 NB: Youtube does not allow to use greater than or Less than symbol here. Put those symbol instead of writing Greater Than Symbol or Less Than Symbol in the formula.