SteveL13
asked on
Trying to format as currency with 4 decimals on a report
I m betting a result like this on a report:
1 per yard
Using this:
=[BuyerTraderCommission] & " per" & " " & DLookUp("[Description]","t blUnitOfMe asuresLU", "[UofMID] = " & [Forms]![frmDealInput]![cb oUnitOfMea sureID])
But I want it to display like:
$1.0000 per yard. ( 4 decimals)
Or if the result was :
.0254 per yard
I want the field to look like:
$0.0254 per yard
How can I do this?
1 per yard
Using this:
=[BuyerTraderCommission] & " per" & " " & DLookUp("[Description]","t
But I want it to display like:
$1.0000 per yard. ( 4 decimals)
Or if the result was :
.0254 per yard
I want the field to look like:
$0.0254 per yard
How can I do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.