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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Decimals gone

Status
Not open for further replies.

CrystaLv

Technical User
May 12, 2006
121
US
I am having a Number field that I am displaying as Amount with decimals. If I choose Custom style - decimals value dissapears and all numbers come up with .00

If I write formula '$' & "" & {t.field} it comes up without decimals...

Can you please, help? I need to display $ 500.34
 
Within the Custom Style you should be setting the rounding and decimals to 2 places.

And if you want to convert it to text, use:

"$" & totext({t.field},2,",")

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top