Data Formatting expression

[Guest]

I currently have this in some money fields that display a PO amount.

{0:c}

What I'd like to do is have just the dollars display (no decimal point &
cents), perhaps round to the next number if the cents are over .50.

How can you do this in a datagrid?

Also, this goes along with being able to have the sort capability as well as
being able to sum these columns.

Thanks,

Sc

 

[John Saunders]

I currently have this in some money fields that display a PO amount.

{0:c}

What I'd like to do is have just the dollars display (no decimal point &
cents), perhaps round to the next number if the cents are over .50.

How can you do this in a datagrid?

Also, this goes along with being able to have the sort capability as well as
being able to sum these columns.

If you need to be able to sort on the visible value, and to show a sum of
the visible values, then you'll have to do that yourself. Just do your
rounding before you display the data.

Use {0:c0} to get no digits after the decimal point.