Forum Discussion

ArunkumarK's avatar
ArunkumarK
Icon for Helper I rankHelper I
7 years ago
Solved

Thousand Separtors

Hello Everyone,

I needs to convert the number into US thousand separtors like below. How to conver the number into highlighed formats like below.

 

Available Number: 125000

Available Format: 1,25,000

Required Format: 125,000

 

Thanks in Advance

Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Arun,

     

    For me it defaults to the US version when I select the field and select comma in modeling. If your default is diferent, you could perhaps force it using Format command such as 

    newdata = FORMAT(data[Column1],"#,0.")
     

     

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Arun,

     

    For me it defaults to the US version when I select the field and select comma in modeling. If your default is diferent, you could perhaps force it using Format command such as 

    newdata = FORMAT(data[Column1],"#,0.")
     

     

    • ArunkumarK's avatar
      ArunkumarK
      Icon for Helper I rankHelper I
      7 years ago

      Nice. Format formula is working fine.

       

      Thanks you so much.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        You are welcome.  Glad it worked for you.