Joanne

What saves even more work is to use VBA to convert all cells in a selection at
once.

No formulas hence no special pasting after.

Chip Pearson has an add-in at his site for doing this.

http://www.cpearson.com/excel/download.htm


Gord

On Wed, 14 Feb 2007 15:48:59 -0500, "JoAnn Paules [MVP]"
wrote:

I just learned about this the other day. (I told you I was an Excel novice.)
That will save me a lot of time at work!