Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Space as thousand seperator using Format()

Hi,   I need to use a space as thousand seperator in my format function:  In this example i used ',' as a seperator and everything is fine: when I change the ',' with a ' ' (space) you see ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , In case comma, it does it automatically

     

    try

    "### ### ###.##"

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Try like

 

"# ###.##"

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amitchandak , 

     

    as you can see below, when the number > 1M , it doesn't show the seperator with your solution.

     

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      4 years ago

      Anonymous , In case comma, it does it automatically

       

      try

      "### ### ###.##"

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I was looking for a more generic or automatic way, but if there is no other solution I will have to do it this way .. 

         

        Thanks for your answers.