Hi,

What you can alternatively do is that type a number 1 in any cell and then
copy this number. Now select the range and then Edit Paste Special
Multiply.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

" wrote in
message ...
Yes but like everyone else I got the leading apostrophe. I guess I should
export as the CVS files and then save as an xls. file.

Or has anyone come up with a way to get rid of the apostrophe?