I have to be careful about using VBA. One - I'm clueless about VBA. Two - my
coworkers know less than I do and it just complicates their life. I really
want them to decide that they want to hire me direct after my contract with
them expires so I try to keep things simple if they are going to be using my
files.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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!