Format of decimal places

rana1978

Registered User.
Local time
Tomorrow, 05:22
Joined
Jun 25, 2009
Messages
25
Friends...

In a Text Box (Text2 ) of my DB report, I’m using the below expression

="Total BDT " & Format$(Sum([Value]),0,0)/1000000 & " Million"

Properties of the text box:
Format : Standard
Decimal Places: 2

Bellow result is being created

Total BDT 25.57775 Million(multi decimal places). But I need the below result

Total BDT 25.58 Million (2 decimal places)

How can I get it?

Would any one suggest me the way, Please…

Rana
 
Take a look at the Round() function.
 
Solved thankxxx
 

Users who are viewing this thread

Back
Top Bottom