Excel Column formatting or VBA -

in excel, want numbers formatted in column.

if enter other number want number have dash (-) after fourth letter. eg. if enter 12345678 want convert 1234-5678.

thanks!

use escape character \

e.g. number format 0000\-0000

enter string above 'custom' number format

from : http://msdn.microsoft.com/en-us/library/0c899ak8(v=vs.110).aspx

to vba:

sub fmt()      range("a1").numberformat = "0000\-0000"  end sub