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#
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 22, 2021

hassanknowledge 

If you mean something like this

when custom format is "#"#,##0.00"#"

  • hassanknowledge's avatar
    hassanknowledge
    Copper Contributor
    Feb 22, 2021

    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.