Hi Stover
should be easy to do

Try the following to make copy+pase a little
bit easier
- enter the formula in C1
- double-click on the lower right corner of the selection mark. This
will fill the formula down
- Select the entire column C (clicking on the heading 'C')
- hit CTRL+C
- goto 'Paste - Special' and choose Values
So all in all 5 steps
For another solution you'll need VBA
Frank