DANG!!!

So, I am guessing you liked the concept then? <g

Rick, it works like a charm. Now, where do want those
pizza's sent?

Glad you liked it. How did you know pizza's are one of my favorite foods?

Thanks so much.

You are quite welcome. I just want to remind you, though, of the caveat I
mentioned earlier...

I should point out that the above idea will not be a viable
one if you have calculations or dependencies on those cells
containing your 1xxxx number.

....and the reason for this caveat is because when you toggle to the
"friendly format", the physical contents of the cell are changed... it is
not simply a "cosmetic" formatting of the content's display like
Cell/Formatting does.

Oh, and I am guessing you like the double-click activation method... I was
originally thinking of a CommandButton or a CheckBox as the activation
method, but chose double-clicking as it was easier to get you to implement
in an example.

Rick