Can I set the default format for phone number?
I know the Format Cells feature of MS Excel. But I want some extensive kinda requirements. Like if user enter phone number +1 923-456-7890 then it should automatically formatted by removing extra spaces, special characters and the country code. And the new format should be (923) 456-7890.
If any help is there it'll be highly appreciated.
<colgroup><col width="90"></colgroup><tbody>
</tbody>
I know the Format Cells feature of MS Excel. But I want some extensive kinda requirements. Like if user enter phone number +1 923-456-7890 then it should automatically formatted by removing extra spaces, special characters and the country code. And the new format should be (923) 456-7890.
If any help is there it'll be highly appreciated.
<colgroup><col width="90"></colgroup><tbody>
</tbody>