Worked for me changing .Value to .Text

Thanks Dave.


Gord

On Wed, 10 Oct 2007 21:37:17 -0500, Dave Peterson
wrote:

Don't change the value in each of the cells.

Select the range (whole column????) and
format|Cells|number tab|Number, 1 decimal place.

And use the .text version.