Hi all, I just received an excel workbook where all the numbers have
been typed with an apostrophe ' in front of them, therefore no
formulas work, i.e., the worksheet does not view them as numbers.
Going in to each cell and removing the apostrophe works, but the table
is way to big to do that for every cell. I tried find/replace, but it
doesn't find the apostrophe's. I also tried reformatting the columns,
copying and using the various forms of "paste special", etc., and have
yet to find anything that works.

Any ideas?

Thanks,

Steve