VB Code to format to SS #

[rmomin]

Hello:

I have numbers in column F as 123456789 format.
I need VB Code to do following.

1st check if total digit is 9 character, if less then 9 character than add "0" in front

Then format the cell value to 123-45-6789 format

Example : 67667779, so this is 8 digit ..this will need to be 067667779

and then to get to proper format to 067-66-7779

Let me know if any questions

Riz

[Pepe Le Mokko]

Are you still using XL2010 ? If not please update your profile. Ths
Do you really need VBA ? A formula will also do the trick

[JohnTopley]

Removed by JT

[Marc L]

Hello,

no need any VBA procedure just using Excel basics so directly with just an appropriate obvious cell format (without any formula) …