tags #

%3CLINGO-SUB%20id%3D%22lingo-sub-2155164%22%20slang%3D%22en-US%22%3Etags%20%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2155164%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20add%20this%20tag%20%22%3CSPAN%3E%23%22%26nbsp%3B%3C%2FSPAN%3Ein%20the%20Excel%20field%20without%20changing%20the%20numbers%20format%2C%20for%20example%26nbsp%3B%3CSPAN%3E%23231%2C00%23.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EBecause%20when%20I%20add%20it%20the%20zeros%20disappear%2C%20for%20example%20231%2C00%26nbsp%3Bbecome%26nbsp%3B%23231%23%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2155164%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2155348%22%20slang%3D%22en-US%22%3ERe%3A%20tags%20%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2155348%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F974362%22%20target%3D%22_blank%22%3E%40hassanknowledge%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20mean%20something%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20160px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256470i5175146D4B2D1D17%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ewhen%20custom%20format%20is%26nbsp%3B%22%23%22%23%2C%23%230.00%22%23%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2155377%22%20slang%3D%22en-US%22%3ERe%3A%20tags%20%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2155377%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%2C%3C%2FP%3E%3CP%3EWhen%20I%20applied%20what%20you%20said%2C%20%22%23%22%23%2C%23%230.00%22%23%22%2C%20I%20found%20this%20problem%2C%26nbsp%3B%20%23123%2C0.00%23%2C%26nbsp%3B%20so%20change%20it%20a%20little%20bit%20and%20used%20this%2C%26nbsp%3B%20%22%23%22%23%23%23%2C00%22%23%22%20%2C%20The%20result%20is%20impressive.%3CBR%20%2F%3EThank%20you%20very%20much%2C%20you%20showed%20me%20the%20beginning%20of%20the%20road.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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