View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Who I Am Who I Am is offline
external usenet poster
 
Posts: 30
Default 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.