Microsoft Excel - Break Down the Number - Asked By Rajender Prasad on 26-Apr-13 10:39 AM

Dear All,

I have a textbox value of phone number, we are passing 1234567890.
After updating it should change to 123-456-7890 format,
please help, waht can be done in this case,\


Regards,
prasad
Harry Boughen replied to Rajender Prasad on 27-Apr-13 03:23 AM
Hi Rajender,
Set the format of the cell to the Custom Format ###-###-####.
Regards
Harry