Thousand Separator for Decimal

[Softbless]

Hi Guys,

I've done some googling and search in this forum, but I still don't have any solutionfor this.

I have a custom field in a custom module, let's call it 'Amount' field.

The field type is Decimal. For some reasons, I cannot use the currency field type.

I need to add thousand separator in that field.

I've tried adding currency_format='true' in listviewdefs :
'AMOUNT' =>
array (
'type' => 'float',
'default' => true,
'label' => 'LBL_AMOUNT',
'currency_format' => true,
'width' => '10%',
),

But it also make the Amount to have $ Currency Symbol : $123,456.00

I just want it to become : 123,456.00

Any help would be very appreciated.

[eitrix]

make a process_record logic hook and format your field for display accordingly