Replace comma with hyphen in list column

Question

I want to add a contact number field, so I am using the inbuilt number field, but it is separating the number with comma, and I want hyphen as a separator.

E.g: Format now - 1,234,567,890.

Format required - 1-234-567-890

Is it possible using OOTB approach?

Answer 1

As Atish mentioned, CSR is a nice way to change the "displayForm" or the list itself.

I tied something little different quickly.

You could use a calculated column and replace the "," with "-".

But the numberlength should be always the same. Not perfect, but maybe also a possible way for your requirement. Here how I did it:

Listview with calculated column:

Formula: =TEXT(Number,"0-000-000-000")

Answer 2

this has already been answered:

Column validation for US phone number format

DVWP that you add to the new form

<script language="javascript" src="http://code.jquery.com/jquery-1.4.2.min.js" type="text/javascript" ></script>
<script language="javascript" src="http://jquery-joshbush.googlecode.com/files/jquery.maskedinput-1.2.2.min.js" type="text/javascript" ></script>
<script language="javascript" type="text/javascript">
jQuery(function($){
   $("input[title='Phone']").mask("9-999-999-999");
});
</script>

you need to also add it to the edit form

Answer 3

Every possible solution has been added. So why not CSR. Execute following code in the OnPreRender

For AllItems view

ctx.ListData.Row.forEach(function(item){
  item.Number= item.Number.replace(/,/g,"-");
  });

For DisplayForm

ctx.ListData.Items[0].Number= ctx.ListData.Items[0].Number.replace(/,/g,"-"); 

Use Cisar for CSR development. Benefits of Cisar

1. It will generate the boilerplate of JSLink
2. Live code edit in console
3. Live test
4. Auto deployment

Answer 4

+1 to Patrick for using the (lesser known) TEXT function to format a number

Here is the Calculated Formula for Number lengths 1 to 10, in a VIEW or DisplayForm

=TEXT(123456
      ,CHOOSE(
              LEN(123456)
              ,"0"
              ,"00"
              ,"000"
              ,"0-000"
              ,"00-000"
              ,"000-000"
              ,"0-000-000"
              ,"00-000-000"
              ,"000-000-000"
              ,"0-000-000-000"))

Replace both 123456 with your Number field reference