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

Decimal Places

Status
Not open for further replies.

9martin

Technical User
Mar 22, 2006
13
US
Hello, how can I change a numeric field to only show two decimal places?

Thanks,
Martin
 
Right-click the field and select "Format Field" from the shortcut menu. Choose one of the formats from the Number tab or click Custom to set by hand.


Bob Suruncle
 
Thanks Bob, This is what I have done in the past, but in this particular report there is not a number tab?? How can I then do a custom setting?

Thanks,
Martin
 
Use a formual to convert it:

val({table.field})

Now you can use it instead of the field to format it as Bob suggested.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top