PHONE formatting. Is there a way to create a macro to format the VALUE of the phone to be either (XXX) XXX-XXX or XXX-XXX-XXXX ??? I obviously can get it to look like this, but the value is just XXXXXXXXXX.


Thanks much in advance!!!