Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formula to change display string format 1

Status
Not open for further replies.

swetham

Programmer
May 5, 2010
257
DE
I have two fields 'A' and 'B'. In 'A' only i have to display 'A/B'. everything is working fine except the display string. I need the display string as 1123 format.
How to write a formula for that?
 
when you convert number to string you can add arguments to remove decimal places and suppress thousand separators

Totext({yournumericstring],0,"")

Ian
 
Thank you so much , i got it. If i want 1123.23 then what will be the syntax?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top