We may use following javascript function to show numbers formatted with thousands separator.
Definition
function formatThousandPlace(orgNum) { arr = orgNum.split('.'); //split integer part & fractional part intPart = arr[0]; //store integer part in a variable fractionPart = arr.length > 1 ? '.' + arr[1] : ''; //store fractional part in a variable var rgx = /(\d+)(\d{3})/; //regexp to find thousand place while (rgx.test(intPart)) { intPart = intPart.replace(rgx, '$1' + ',' + '$2'); //replace integer part after inserting a comma in the thousandth place } document.write(intPart + fractionPart); //write final value to the document }
Function Call
Now, we can use it anywhere in the document where we want to show those numbers. For example: it may inside normal html elements or some dynamic ASP.Net controls like GridView, DataList, FormView etc.
<script language="javascript">formatThousandPlace('10000000.00')</script>
While calling this from ItemTemplate of an ASP GridView the syntax will be
<asp:TemplateField HeaderText="Price"> <ItemTemplate> <script language="javascript">formatThousandPlace('<%#Eval("SalePrice") %>')</script> </ItemTemplate> </asp:TemplateField>
I hope this is helpful.
Advertisements