Page 1 of 1

Formatting Decimal (money) to two Decimal Places

Posted: Mon Feb 15, 2016 2:50 pm
by jp2code
My Decimal datatype values are printing fine, but they are running out to 4 decimal places.

How do I specify that I only want to display 2 decimal places? Other values, for whatever reason, are showing no decimal places.
getgreenshot_org.jpg
getgreenshot_org.jpg (170.65 KiB) Viewed 14868 times

Re: Formatting Decimal (money) to two Decimal Places

Posted: Mon Feb 15, 2016 5:27 pm
by jp2code
Found it!

Code: Select all

Round(value,2)
Sorry for the trouble. :)

Re: Formatting Decimal (money) to two Decimal Places

Posted: Tue Feb 16, 2016 10:58 am
by HighAley
Hello, Joe.

Yes, you could use Round function or Text Format property.

Thank you.