+ Reply to Thread
Results 1 to 5 of 5

Custom Format Cells (putting comma in Numbers in Nepalese Style)

  1. #1
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Custom Format Cells (putting comma in Numbers in Nepalese Style)

    Hey All!

    Is there any way that i can format my Numbers in cell and put the commas in the way i want. Generally and universally, excel formats the numbers in hundreds coma hundred thousands coma hundred millions coma and so on after three digits i.e. 100,000,000 ...

    But in our Nepalese style, we have something different number accounting formats..( hundreds coma ten thousands coma millions coma and so on OR hundreds, Ten thousands, Lakhs, Ten lakhs, Crore and so on) i.e 1,00,00,00,000

    Firstly coma after three digits and then two digits afterwards..
    So, can anyone help me on formatting the cells based on these rules??

    Thanks
    Last edited by meus; 02-22-2016 at 04:27 AM.

  2. #2
    Registered User
    Join Date
    02-09-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Custom Format Cells (putting comma in Numbers in Nepalese Style)

    Please try below custom number format.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: Custom Format Cells (putting comma in Numbers in Nepalese Style)

    Hey there..
    It works only till millions.. If i add more zeros, then it is messed up..
    Thanks anyway.

  4. #4
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: Custom Format Cells (putting comma in Numbers in Nepalese Style)

    Searched on google, youtube but i could not solve this

  5. #5
    Registered User
    Join Date
    02-09-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Custom Format Cells (putting comma in Numbers in Nepalese Style)

    Probably a VBA code would help where you need to check the number and then format it. For example if the number is in thousands then the number format is ##,##0, if it is in lakhs the number format is ##\,##\,##0 and so on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 07-06-2015, 07:27 PM
  2. macro to generate a list of cells using a specific custom cell style
    By sonofamonkey10 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2015, 10:39 AM
  3. Replies: 9
    Last Post: 10-16-2013, 06:17 AM
  4. problem with converting numbers to TEXT format and applying comma style
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-23-2012, 10:43 AM
  5. numbers with `comma style` in text format
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2012, 11:37 AM
  6. Replies: 7
    Last Post: 06-18-2009, 04:41 AM
  7. Replies: 1
    Last Post: 05-13-2006, 09:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1