Cell Event Only Affects One Column
The issue here is, I guess, that I do not type the phone number into a
cell in the column (if I type it, of course I will follow my own
format). I copy-paste them from different sources. They may look like
999.999.9999 or (999)-999-9999
I want a macro to change the format after I hit ENTER.
Per your suggestion, I format the column as 000-000-0000. But it does
not work.
Thank you for your prompt reply.
|