Forum Discussion

hassanknowledge's avatar
hassanknowledge
Copper Contributor
Feb 22, 2021

tags #

I want to add this tag "#" in the Excel field without changing the numbers format, for example #231,00#.

Because when I add it the zeros disappear, for example 231,00 become #231#

3 Replies

    • hassanknowledge's avatar
      hassanknowledge
      Copper Contributor

      SergeiBaklan Thank you,

      When I applied what you said, "#"#,##0.00"#", I found this problem,  #123,0.00#,  so change it a little bit and used this,  "#"###,00"#" , The result is impressive.
      Thank you very much, you showed me the beginning of the road.