Format type money

Apr 21 at 10:30 AM
Hi all
I have a grid with a column type "money"

The grid shows 4 decimals but I want to format it to 2 decimal. is it possible?

I am playing with the format function but I am not able to make it works

.Filterable(true).Format("{0:#.##}")
May 19 at 9:12 AM
HI eisesaba,

Use:

.Format("{0:#,###0.00}")

works well.

You also may want to consider using a currency symbol as well like this:

.Format("£{0:#,###0.00}")

HTH
Aug 29 at 2:10 PM
works fine!

thanks