Forum Discussion

harib's avatar
harib
Post Patron
6 years ago
Solved

How to remove zeros from after decimal point

Hi,   I would like to remove zeros from after decimal point like below output.  is it possible to remove and get the out put eactly like below image.     Thanks in advance  
Need Help
Show and Tell
  • VasTg's avatar
    VasTg
    6 years ago

    harib 

     

    Change the format to #,###,##0.##

VasTg's avatar
VasTg
Memorable Member
6 years ago

harib 

 

Use Custom format in model tab.

 

 

If it helps, mark it as solution

Kudos are nice too

harib's avatar
harib
Post Patron
6 years ago

VasTg 

 

0 is missing . Let's say if it is 0.25 when we format it's giving .25 only. 0.25 has to come

  • VasTg's avatar
    VasTg
    Memorable Member
    6 years ago

    harib 

     

    Change the format to #,###,##0.##

    • harib's avatar
      harib
      Post Patron
      6 years ago

      VasTg 

       

      Yes. It's working perfectly. Thanks a lot VasTg . ğŸ˜Š

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Could you please explain the logic?