Not sure how you want to implement this, but the following should give you
an idea how to proceed...

Selection.NumberFormat = "[<=9999999]###-####;(###) ###-####"

--
Rick (MVP - Excel)


"fred" wrote in message
...
Hello,
When using Excel automation, how to programmatically format all
numbers in the specified column as the phone numbers.
I can see it in the Excel menu there is possible to do
FormatSpecialPhone Numbers.
How to do that programmatically?
Thanks,
Fred