Okay I've ran into an unexpected issue.
I used the macro to change all phone number to format xxx.xxx.xxxx
When I put the mouse on the cell and look in the Formula Bar, the number
shows up as xxxxxxxxxx (no decimals). This is the case with all numbers and
I'm not sure how this will impact me later. Why is this the case?
Thanks

"Ron Rosenfeld" wrote in message
...

On Thu, 28 Oct 2010 15:13:41 -0500, "JCO"
wrote:

Awesome.. that works great. thanks so much

Glad to help. Thanks for the feedback.