0

In Google Sheet, select a cell having at least 6 digits number in it, then go to Format > Number > Custom number format > (fill the inbox by [>9999999]##,##,##,##0;[>99999]##,##,##0;##,##0 ) and hit Apply.

If the entered number is 195665 then it was showing Indian format lakhs and crores as 1,95,665 but now it shows 195,665. See this.

Is there any other number format, which still works in Google sheet ? (It should not be formula like this answer, but it should be just a number formatting).

Anit
  • 84
  • 9
  • Was this working at some point? Can you try with the following? `[>9999999]##\,##\,##\,##0;[>99999]##\,##\,##0;##,##0` https://stackoverflow.com/a/34690816 – Iamblichus Jun 01 '22 at 10:26
  • Yes it was working nice, but now it is not working. Thank you, the format suggested by you works well. – Anit Jun 02 '22 at 12:05
  • However, the format suggested by you works in sheet, when we apply through menu in sheet. But in App script, I run `var trialSheet = ss.getSheetByName("TrialSheet");` `trialSheet.getRange("J2").setNumberFormat('[>9999999]##\,##\,##\,##0;[>99999]##\,##\,##0;##,##0');`. It doesn't work. When I check, which format is applied to "J2", it was [>9999999]##,##,##,##0;[>99999]##,##,##0;##,##0. – Anit Jun 02 '22 at 12:44
  • If setting via script, try with `.setNumberFormat('[>9999999]##\\,##\\,##\\,##0;[>99999]##\\,##\\,##0;##,##0');` – Iamblichus Jun 02 '22 at 12:54

0 Answers0