Macro inserting comma & space

I have a column with 10 digits I need to create a macro that puts a comma and a space after the 3rd digit I found a macro on this forum and tried to modify I can get it to add the comma and the space but the other 7 digits erase any help would be appreciated.


simple one column of phone numbers
9999991111

needs to be
999, 9991111

orginal macro.

Please Login or Register  to view this content.

I changed to this

Please Login or Register  to view this content.

Know I am missing something just cannot find it.

Thanks

Awesome THANKS!

try

Please Login or Register  to view this content.