View Single Post
  #1   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

Hello:

One column is dedicated to phone number. When I copy-paste phone number
to it, I want all phone numbers in the same format like 999-999-9999. I
don't want to see 999.999.9999 or (999) 999-9999 or (999)-999-9999

I want this event gets triggered only after I paste the phone number
into a cell in the column and hit RETURN

Could you help?