I am trying to format numbers in Usage Quantity column with comma using the code snippet below.
<COLS sheet="Market <COL N="market_name" L="Market" F="" P="" A="" W="15mm" R="1" S="" /> <COL N="curr_amount" L="Charge Amount" F="$" P="" A="end" W="15mm" R="1" S="" /> <COL N="tax_amount" L="Tax Amount" F="$" P="" A="end" W="15mm" R="1" S="" /> <COL N="bill_count" L="Total Bills" F="" P="" A="end" W="20mm" R="1" S="" /> <COL N="total_usage" L="Usage Qty" F="" P="" A="end" W="20mm" R="1" S="" /> </COLS> Desired output is the numbers in Usage Qty with commas
I have tried using F="," F="#" F="type:num"
Thanks //Srikanth
No comments:
Post a Comment