XML : XML format number with comma

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 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