my question is this. I am trying to have standard data throughout my
worksheet, ie when i input a phone #, it will always appear as (321)
456-7890. I tried formatting the cell and that works when data is typed in.
However, the majority of the data will be copied and pasted into the
worksheet. Do formatted cells not work for pasted data? Is writing a quick
script the only way to accomplish this?

Thanks in Advance.