I'm trying to replace text with number values via Find and Replace but when I
try to sum the number values, nothing adds up. I've tried to format the
cells to Number from General, but Excel doesn't seem to want to do it. All
the numbers I've put in using Find and Replace just stay in General format.
If I manually type the number in, they sum up fine. But I've got way too
much text to do it all by hand. Any ideas? Thanks!