[Solved] Currency defaults

[Gareth]

Hi,

I've created a grid with batch in place editing with a currency column.

If I click in a cell in the currency column with no entry in it I get the edit box but, if I click out leaving the box empty, it changes to $0.00.

Is there any way of telling it to leave blank text boxes empty and not put $0.00 in there?

Thanks

Gareth

[Gareth]

I've sorted this myself - rather than using the currency datatype I've applied formatting using the ClientTemplate:

.ClientTemplate("<#=formatter(RRPIncVAT)#>")

where formatter is a custom javascript function:

function formatter(value) {
if (value) {
return '£' + $.telerik.formatString('{0:###,#0.00}', value);
} else {
return '';
}
}

I wasn't 100% sure about the formatString function - I can't find any documentation on it but it seems to work

Gareth