tags #

New Contributor

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 

If you mean something like this

image.png

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

@Sergei Baklan 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.

@hassanknowledge , you are welcome, glad it helped